Removing completely empty column ?

[malhotra6675]

Is it possible to remove or hide empty columns in a matrix? Depending on the filtering in my slicers, some of my measures may not return any data for my selections.

Power BI does a great job of removing blank rows, but can it somehow also remove blank measure columns?

Need help?

[rohit1991 · Accepted solution]

Hii @malhotra6675 

You can achieve this through steps below :

1. Create a calculation group with a calculation item for each measure
1. Each calculation item expression is just a measure reference.
2. Place the calculation item column in columns and an arbitrary measure in Values.