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 Everyone,
I am using a card that shows the average of a column. It is interactive with the table that has the column. When i click on a item on the table the number on the card changes which is great and what I want. But when i am not selecting any item on the table it just shows the average of the entire column.
My question is, is there a way to have the card show nothing/empty if nothing is selected from the table and only show value once something is selected on the table.
Below is an example :
Clumn Text | Column Value |
A | 1 |
B | 2 |
C | 3 |
D | 4 |
Currently, card is showing the average of 2.5 (average of entire Column Value) when nothing is selected. I want the card to show Blank/emplty if nothing is sleceted from the Table ablove and provide a card value when Something is selected in the table, for example if I select A & B together it shoud give the average of 1.5 in the card.
Thanks
Solved! Go to Solution.
Hi @Anonymous ,
You can use ISFILTERED() or ISCROSSFILTERED() functions to determine if the table is selected.
Hi,
You can hide the blank value using a Conditional Formatting rule on the Callout Value. The rule is 'if blank' then select the same color as the card or canvas background.
I have created a video tutorial on how to create the conditional rule: https://youtu.be/Xsmbfpa4oCA
Hi @Anonymous ,
You can use ISFILTERED() or ISCROSSFILTERED() functions to determine if the table is selected.
Thanks a lot @Toerstad and @v-eachen-msft , for my case ISFILTERED worked for me and getting exactly what I wanted.
Much appreciated
Hi @Anonymous ,
Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.
Hi.
You could create a measure like this, and add it to a card-visual. Then you could select one ore more rows from a table- or matrix-visual and it will return the average of the values of the selected rows.
AverageValue = IF( ISCROSSFILTERED('Table'[Column Text]), AVERAGE('Table'[Column Value]), "" )
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 |
---|---|
105 | |
97 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |