Scenario: You've created a dashboard-looking Power BI report that has a filter. Most visuals on a report page need to show only data for the selected filter but some must ignore the filter. Solution: There are several solutions to achieve this goal depending on requirements. Let's start with the no-brainer and move down in complexity. Move the unfiltered visuals to another report page -- Slicers…
Planning to attend the PASS Summit this year? The PASS Summit is the go-to conference for data professionals that will take place November 6-9, in Seattle, WA. You have two options to register: Early bird registration priced at $1,699 has started and it will continue until March 23, 2018. As a bonus, use code LGSTRMZB8 at registration to get streaming access to all PASS Summit 2017…
Scenario: You want to overwrite the formatting of some field in a Power BI Visual, such as in the case of showing the field in one visual with decimals and then in another without decimals. Or, you might want to overwrite the default format when connected live to a semantic model. You search left and right, bing the Internet, and still no clue as to…
In my "Understanding Dates in Power BI Quick Measures" blog, I mentioned that having a Date table is a best practice but Quick Measures didn't support it. Fortunately, the February update of Power BI Desktop fixes this. Now you can mark a Data table as such, as you've been able to do in Excel Power Pivot since the beginning. Marking a date table accomplishes three…
Scenario: You have a concatenated field stored in a table. For example, a medical claim might have several denial reasons. Instead of representing this as a Many-to-Many relationship, you've decided to store this a comma-delimited field, such as to allow the user to see all codes on one row. However, users are asking to produce counts grouped by each reason code, such as this one:…
A while back I wrote about the ROI for BI and this blog happened to be one of my post popular blogs. I'm a big fan of a BI semantic model for the reasons I outlined in my "Why Semantic Layer" newsletter. Although written five years ago, these are still valid reasons and a semantic model plays a prominent role in every organizational BI solution.…
A week ago, I wrote that Power BI sharing improved by giving you the ability to include specific reports and dashboards in an app. Recall that that there are three ways to share Power BI content: workspaces, apps, and dashboard sharing. Only the last two lets you share content out of a workspace, such as by sharing with free users if the workspace is in…
MS BI fans, join us for the next Atlanta MS BI and Power BI Group meeting on January 29th at 6:30 PM. Julie Smith will hack sweet reports in Power BI. Innovative Architects will sponsor the meeting. And your humble correspondent will show you two new cool Power BI features: integration with PowerApps and Q&A in Power BI Desktop. For more details, visit our group page. Presentation:…
One Power BI aspect that I'm not crazy about is sharing. It's my experience that most organization could benefit from a simplified sharing where users or groups are added to a workspace with different roles and permissions, such as Content Manager, Browser, Administrator. This could have worked conceptually like SSRS security. At some point, we could have nested workspaces and custom roles, such as a…
Natural queries (aka Q&A) has been a prominent feature since Power BI Service existed. Wouldn't be nice to do the same in the Power BI Desktop? You can, but make sure to enable first Q&A from File, Options and Settings, Options ("Preview features") tab because it's currently a preview feature. Once you do this and restart Power BI Desktop, you should see "Ask A Question"…