Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.
Data Groups ---
We are grouping states with name Omni - with in Omni we are again grouping Offline and Online states.
We have an Matrix visual with in that for Rows - we are using State (groups) (groups), State (groups), State.
Below is the snip --
Here, we have to hide first two rows i,e. Omni and Offline.
Please suggest how we can achieve this in Power BI.
Thanks,
HI @Anil_katta,
For power bi visuals, they will auto hide the row/column which not existed correspond values. Since these two rows are the subtotal level, they will auto summary the child level values, so they are not suitable for auto hide features.
BTW, I also think it is impossible to directly hide or custom on these category fields.
Regards,
Xiaoxin Sheng
Select the matrix, go to the filter panel, make sure your state (groups) (groups) is there, in basic filtering uncheck your desired values
Hi @Anil_katta
The question is unclear, please share a link to pbix with a dummy example and show the desired result.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
76 | |
75 | |
70 | |
47 | |
41 |
User | Count |
---|---|
64 | |
41 | |
32 | |
30 | |
28 |