Earlier this week I posted a challenge for creating a dynamic date filter using DAX. If you want to see the challenge first and see if you can solve it, check out that post first. If you just want to see how it’s done, read on… The Challenge Based on the Date field of […]
This week I’m doing something a little bit different. I wanted to post a challenge that I think could apply to many business scenarios, and see the different approaches that people might take to get to the same solution. The challenge is the following: Based on Date field of when a Client last had an […]
This week the Harris County Appraisal District (HCAD) completed its final round of updates to property values in the county for 2018. With this data we are now able to see a more clear picture of the impact that Harvey had on property values in the Houston metroplex. Quick Rundown of the Numbers A total […]
This week we look at some golf numbers from the PGA Tour and try to find some patterns in the data worth sharing in a Power BI report. The inspiration for this post came from watching Tiger Woods make a run for the PGA Championship this past Sunday. Although he came up short, it made […]
With Power BI Desktop’s July update now out for a few weeks, I wanted to write a quick review of the new features, focusing on my Top 3 for this month’s update. 1. Visual Headers Having the ability to completely remove the hovering visual headers from each visual, in addition to moving it inside the […]
Earlier this week Serena Williams made news regarding her take on how often she is being required to go through drug testing. Williams took to Twitter to voice her opinion, and suggested that she is being singled out compared to the number of drug tests her peers are having to go through. I figured this […]
With the Lakers making headlines this season due to all their recent trades, I wanted to do some analysis on the overall number of trades that have occurred so far this season and see which teams are making the most moves. I pulled some data from Wikipedia for all the trades that have occurred so […]
This week I’m starting a new series of posts aiming to leverage Power BI to visualize data about a current event for that week. With the World Cup coming to an end today, I wanted to share some insights around the number of players from the Premier League that participated in the World Cup. In […]
While working with Dates in DAX, you may have come across an interesting behavior when working with the DATEADD() function. If have used this function in SQL, you have a good idea of how the function works and the parameters you pass to it in order to shift a date forward or backwards. However, this […]
With the October release of Power BI Desktop, users have the ability to leverage 2 really cool features: Bookmarks and the Selection Pane. With bookmarks, you can create a custom/modified view of your report and save a version of that state, allowing you to go back to that view either through a PowerPoint-like presentation, or […]
Thanks for sharing nice information about Hadoop and azure (...)
Hello, is there an option to have different folder color (...)
Thank you very much for such informations. but I want to (...)
Hi, I am exactly in the same problem. Even after 3 years of (...)
Hi this was really helpful. I'm using a digital solution (...)
Another option to add to this list for options to display (...)
There is a product called VuePilot that can help you with (...)
Good stuff! Go Reds
I am looking for a way to access the dashboard you (...)
Amazing post! Thank You for sharing such helpful (...)
Serena Williams is great player, but mostly wins from her (...)
Nice post. Is it possible to get a download of this .pbix (...)
When I use this method it does work, so thanks so much for (...)
Hi Craig - thanks. I've updated
Hello, it's great article. Is it possible somehow set (...)
Hey Victor, looks like the link to my site no longer works. (...)
Is there an option for full screen mode when using PowerBI (...)
Great post. no words to explain how thank you we
Hello, Thanks for this article! Any idea how to remove (...)
Lovely! Saved me a days work
What are the minimum rights necessary to be able to (...)
Good job ! Thank
OMG...Did not expect such a workaround could be available.I (...)
Hi AR - your calculated column only returns 8 clients for (...)
Activity = switch(true(), datediff(Clients[Last Activity (...)
Hi Venkat - I included link to download the file
Please share the PBIX
Hello, I am using Azure stream analytics to get telemetry (...)
This is awesome work, in one report you have handled many (...)
Thank
Hello Victor, it's fine now with lowercase thank you (...)
Hey Marin - make sure that "chromeless" is all lowercase. (...)
Hello, thanks for this tutorial it looks great (...)
Hello, thanks for this tutorial it looks great (...)
Hey Bob - check out this plug in for Chrome: (...)
Is there a way to rotate through multiple dashboards? We (...)
This is pretty neat. There's a new year out. I'm working (...)
Glad to hear that you found it
Very cool Victor! I'm getting ready to argue my property (...)
Thanks Adilson - I think both of them would
One quick note: The parameter, at the end of the URL must (...)
Hi Rashid - in that case you will need to map the server (...)
Hey thanks for the great post I am getting the same (...)
I am having a live screen running. One problem i faced is (...)
Hi , I have an issue with SSRS 2016 mobile reports. I tried (...)
Hi Judy - You will need the Enterprise version to use the (...)
Power BI reports in SQL Server Reporting Services can you (...)
Do you know if you need to have SQL 2016 Enterprise version (...)
Brutal!!!
Did you update the Twitter API keys with the ones from your (...)
Looks like I've got pass that but getting a " token has an (...)
Hi DS - can you try re-building the solution and seeing if (...)
Great blog post! I seem to get an error when running the (...)
[…] my last post I pointed out the different (...)