Displaying Slicer Selections

Rob Collie shows an easy method to concatenate selected values for display in Excel and Power BI:

Measure Step 2: Dealing with No (aka All) Selections on Slicer

The original measure above is really awkward when the user has made NO selection on a slicer – because it can then return a REALLY long list!

To deal with that case, we add an IF to the measure to detect precisely that case, and then return “All.”

Read on for the code, as well as some caveats and additional hints.

Related Posts

Dynamic Top N in Power BI

Gerhard Brueckl shows how to create a Top N slicer in Power BI, as well as some of the problems you might need to work through: As I said, this pretty much depends on the business requirements and after discussing that in length with the users, the solution is usually to simply add an “Others” row that […]

Read More

Storing Large Images in Power BI

Chris Webb shows us how to store a large image in Power BI: Jason Thomas and Gerhard Brueckl have both blogged on the subject of storing images as text inside a Power BI dataset:http://sqljason.com/2018/01/embedding-images-in-power-bi-using-base64.htmlhttps://blog.gbrueckl.at/2018/01/storing-images-powerbi-analysis-services-data-models/ Since they wrote those posts, however, Power BI has added the ability to set the Data Category property on measures as […]

Read More

Categories

March 2017
MTWTFSS
« Feb Apr »
 12345
6789101112
13141516171819
20212223242526
2728293031