Forum Discussion

malhotra6675's avatar
malhotra6675
Advocate II
8 months ago
Solved

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 :

    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.

     

1 Reply

  • 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.