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.
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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |