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.
Hello everyone,
Is it possible to create a measure that sends a Card behind a table if I have selected a single value in the slicer?
Here's my problem:
I have a page with a table and a card that should show values only if a slicer had a single value selected.
To solve this, I used the formula:
SlicerCheck = if(calculate(distinctcount([SlicerColumn]),allselected([SlicerColumn]))=1,"Y","N")
That I found in this topic:
But this measure does not work with the Card, only with the table.
Searching a little more, I found this "solution":
https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/
Basically I can create a card that becomes transparent when I have a value selected in the slicer.
But the transparent card is in front of the table, preventing me from clicking to trigger spotlight mode, for example.
Any ideas on how to solve this problem?
Best Regards
Hi @Anonymous
A workaround is as below:
Resize the table visual as below
Turn off the "Visual header" option for the card visual
Put card visual on top of table visual, group them (new feature since 2019/8, more details here)
Save and publish to Power BI Service
Hello @v-juanli-msft , thanks for your help.
Unfortunately, my PBI is still in the June update. Software updates at the company I work take a while to happen 😞
Hi @Anonymous
You could download lastest version here. It is free.
The new version always supports older version Power BI files.
After changing reports with new version Power BI Desktop, you could publish the report to Power BI Service to replace the old one.
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |