The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |