Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a card on my dashboard that is meant to display the date of a selected event. The events are listed in a matrix along with other data. Currently the date on the card is making me select either the earliest or latest date. What I want is for the card to display the message "Select Event" when a specific event is not selected from the matrix. I've tried using slectedvalue, but I get an error message saying it will not work with variant type data.
Solved! Go to Solution.
IF(HASONEVALUE(...),show event, "Select Event"
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
To clarify, I am looking for help writting the DAX code so that a card will only display a date when an event is clicked on in the matrix. When an event is not selected, I want the card to display the message "Select Event".
IF(HASONEVALUE(...),show event, "Select Event"
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |