Forum Discussion

JustinDoh1's avatar
JustinDoh1
Post Prodigy
4 years ago
Solved

Hide column using Conditional Logic

I am trying to hide column (in Matrix visual) based on the date.

 

So, from July 2022, I am trying to hide one column.

 

I am sharing my PBIX file here.

 

Currently, from July 2022, there will be no data for Rating1, so I am trying to hide this column if user selects July 2022 and going forward.

 

Until June 2022, there was data for Rating1, so if user selects June 2022 or previous month (which I only display June 2022 here), it should show visual for Rating1 still as well.

 

July 2022:

June 2022:

So, I am trying to create a logic to hide Rating1 if date >= 'July 2022' , something like that.

 

How do I go about doing this?

 

 

Need Help
  • Arul's avatar
    Arul
    4 years ago

    JustinDoh1 ,

    I have tried to hide the values in the column but getting rid off them from the table I am not sure. Check if it helps or not.

    Thanks,

    Arul

     

3 Replies

  • Arul's avatar
    Arul
    Super User
    4 years ago

    JustinDoh1 ,

    I have tried to hide the values in the column but getting rid off them from the table I am not sure. Check if it helps or not.

    Thanks,

    Arul

     

    • JustinDoh1's avatar
      JustinDoh1
      Post Prodigy
      4 years ago

      Arul 

      I have a question.

      Is there way to automatically size down the width of the column if there is no value (vice versa: automatically size up the column if there is a data)?

      Thanks.