Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I hope each of you are well. I am a newer PowerBI user and am running into an issue with one of the dashboards I have created and am hoping the community can help me.
One of the pages in my report has a visualization card that reflects percentage to a specific goal. I have a table below the card that breaks out specific employees and includes their percent to goal information. Right now, when a specific row is selected in the table, the card adjusts to reflect the percent to goal for that specific individual (which is great). The issue I have is that when no specific row is selected, the card shows a sum of all percentages (shown below) which is not useful. Question: Is there a way to have a visualization card like this reflect as blank until a specific row is selected? My hope was to have the card highlight the percent to goal but I find the sum it includes confusing since people reviewing the report wonder what that total relates to. Any help would be appreciated! Thank you.
View when no rows are selected:
View when a specific row is selected:
Solved! Go to Solution.
I think this depends on what you mean by row is selected. Have a look at the ISFILTERED function. You could combine that with a IF statement. Something like: IF(ISFILTERED([condition), [Result Measure], BLANK())
Thank you @vicky_ . I will look into that and see if that resolves the issue. Appreciate it!
I think this depends on what you mean by row is selected. Have a look at the ISFILTERED function. You could combine that with a IF statement. Something like: IF(ISFILTERED([condition), [Result Measure], BLANK())
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |