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.
Hi,
I have a scatter plot of a TableA, that plots ValueX and ValueY. TableA also has a Description text column.
Is there a way to show the description of a record in TableA only when it is selected from the scatter plot? Right now I just have the description text box set to First, which means, by default when nothing is selected, it shows the description of the first record. I want it to be blank until a value is actually selected on the scatter plot.
Is there a way to do this?
Thank you.
Solved! Go to Solution.
@Anonymous Perhaps:
Measure = IF(HASONEVALUE('TableA'[Description]),MAX('TableA'[Description]),BLANK())
@Anonymous Perhaps:
Measure = IF(HASONEVALUE('TableA'[Description]),MAX('TableA'[Description]),BLANK())
Thanks Greg, that worked. I replaced Blank() with "" so the box is completely empty when nothing is selected.
You don't have to do this, but I would love if you could give me a brief explanation of what that expression is saying. I am still trying to improve on my DAX.
Thanks
@Anonymous Sure thing. Basically HASONEVALUE checks the specified column and determines if there is a single value for that column or multiple values. When nothing is selected, all rows are in context and thus HASONEVALUE evalulates to FALSE (more than one value). But, when you choose a single point, HASONEVALUE evaluates to TRUE (single value). You can see other more advanced examples of this basic concept if you want to do some really wild stuff with your titles: The Most Amazing, Mind Blowing Dynamic Slicer Titl... - Microsoft Power BI Community
Note that HASONEVALUE is kind of sugar sytax for COUNTROWS('Table')=1
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 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |