Forum Discussion
malhotra6675
8 months agoAdvocate II
Removing completely empty column ?
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?
Hii malhotra6675
You can achieve this through steps below :
- Create a calculation group with a calculation item for each measure
- Each calculation item expression is just a measure reference.
- Place the calculation item column in columns and an arbitrary measure in Values.
1 Reply
- rohit1991Super User
Hii malhotra6675
You can achieve this through steps below :
- Create a calculation group with a calculation item for each measure
- Each calculation item expression is just a measure reference.
- Place the calculation item column in columns and an arbitrary measure in Values.