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.
Hello @pasit,
1. Create a new calculated measure that checks if any of the measures at the lowest level of your hierarchy has a value.
ShowRow = IF(ISBLANK([Sales]), BLANK(), 1)
2. Add the new calculated measure to your matrix alongside your other measures.
3. Select the matrix visual, go to the "Format" pane, and navigate to the "Conditional formatting" section. Choose "Background color" under "Font color" and select the "Field value" option. In the "Based on field" dropdown, choose the calculated measure you created in step 1 (ShowRow). Set the formatting options for the blank rows, such as setting the font color to match the background color or choosing a different background color to make the row appear hidden.
Should you need further assistance please don't hesitate to reach out to me.
User | Count |
---|---|
26 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
32 | |
14 | |
11 | |
10 | |
9 |