When we want to be sure that we made the right selection 💡
Have you ever found yourself in a situation where you sliced and diced your report, drew some insights, but when it comes to present or share those findings with others you had to double-check that you selected the right stuff?
I cannot tell you how many times I had to double-check the slicer selection to make sure that I have done the right thing.
To solve the above problem and to help my report consumers I usually like to highlight one way or another the slicer selection.
Options and DAX Codes
Let’s start with a simple SELECTEDVALUE:
Secondly, we can create a 0-1 kind of measure. Meaning that it’s either going to show a single selection or flag that users have selected multiple elements:
And lastly, a version of the measure where all selected elements are concatenated with a comma (“,”):
Make sure to watch the video below 👇 to hear when and how should you use these DAX formulas.
And if you decide to replicate any of these methods, please let me know down in the comments below along with any other suggestion or solution that you may found in Power BI to solve the same problem.
Subscribe below 👇 to get full access to BI-Lingual Analytics Materials
💰 It’s free 💰
🙏Thanks for watching and if you liked this video please hit the 👍 button.
📢 Also be sure to subscribe to the channel so you never miss a new video.