Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am using four card visuals that return values based on a slicer. Not all slicer options have data for all card visuals. The data comes from a published dataset which I cannot edit/transform.
Region | Action_1 | Action_2 | Action_3 | Action_4 |
North | Research | Initiate | ||
South | Research | Initiate | Agreement | |
East | Research | Initiate | Agreement | |
West | Agreement in Writing | Copies to all parties | Annual review | Annual approval |
Is there a DAX formula that result in a card visual being invisible when there is no data in the field?
Hi @JackieHerout
You can use conditional formating of value and background to make the card blend with the background color. Something like:
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
8 | |
6 |