Forum Discussion

malhotra6675's avatar
malhotra6675
Icon for Advocate II rankAdvocate II
9 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 remo...
Need Help
  • rohit1991's avatar
    rohit1991
    9 months ago

    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.

     

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
9 months ago

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.