Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have a view where i have used multiple cards, When i open the Dashboard it is showing some default informaction or the First information Insted of that i want to show nothing on my cards. When they filter something using sliers the cards should update based on that.
Can you use the HasOneValue function in a measure?
https://learn.microsoft.com/en-us/dax/hasonevalue-function-dax
When you first load the page, the function will return false, so you can return BLANK or 0 or a message about selecting something using the slicer.
Then when the user has made a selection, the function will return true and you can return the result they are looking for.
This may not work if users can select multiple values for a single column.
User | Count |
---|---|
48 | |
31 | |
27 | |
26 | |
26 |
User | Count |
---|---|
60 | |
56 | |
36 | |
32 | |
28 |