Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
How to display NA in the card visual when no values are selected from the slicer visual?
Here is the snapshot of the slicer and the card visual where card visual needs to be NA when nothing is selected from the slicer visual. When a value is selected from the slicer visual, the card values displays the count of that value. So, when nothing is selected, it needs to display NA.
Appreciate your time and support in advance :))
Cheers!
Solved! Go to Solution.
You can use the following measure to achieve what you're after:
MEASURE = IF ( ISFILTERED ( Table[Column] ) , SELECTEDVALUE ( Table[Column] ) , "NA" )
Output of unselected is:
Example of a selected value is:
Hope this helps 🙂
Theo
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Hi Theo,
It worked out. I just changed the selectedvalue to count and i got both the things i wanted.
Thank you heaps for your time and support.
Cheers!
You can use the following measure to achieve what you're after:
MEASURE = IF ( ISFILTERED ( Table[Column] ) , SELECTEDVALUE ( Table[Column] ) , "NA" )
Output of unselected is:
Example of a selected value is:
Hope this helps 🙂
Theo
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Thank you Theo!
I have tried using this measure but I am getting the Form ID rather than the count of it.
Hi Theo,
It worked out. I just changed the selectedvalue to count and i got both the things i wanted.
Thank you heaps for your time and support.
Cheers!
@NKotak_Leecare sincere apologies! I only saw your comment after you send the most recent one! Apologies but well done on getting a solution!
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
All good, Theo! Thank you for helping me out with the main formula :))
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
96 | |
90 | |
79 | |
67 |
User | Count |
---|---|
153 | |
125 | |
114 | |
111 | |
95 |