Forum Discussion

SwathiBadveli's avatar
SwathiBadveli
Icon for Helper I rankHelper I
2 years ago
Solved

Hide a column in matrix

Hi All,   I have a requirement from user to hide a sub column because that column is repeated. In the above snip sum of benchmark column it should display only one for 1M period and not for ...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi SwathiBadveli 
    I think that you still can create a table with wanted categories from both tables.

    If you attach some dummy pix, I will try to create it

    Anyway, there is no generic solution for this issue, so it can be or solution with creating a "third table" or with minimizing columns width like you did.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

SwathiBadveli's avatar
SwathiBadveli
Icon for Helper I rankHelper I
2 years ago

Hi RItaf,

 

Thaks for solution, but for scenario its not working as expected because we are taking the columns from different tables.

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    2 years ago

    Hi SwathiBadveli 
    I think that you still can create a table with wanted categories from both tables.

    If you attach some dummy pix, I will try to create it

    Anyway, there is no generic solution for this issue, so it can be or solution with creating a "third table" or with minimizing columns width like you did.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

    • SwathiBadveli's avatar
      SwathiBadveli
      Icon for Helper I rankHelper I
      2 years ago

      Hi,
      Assume this my sample data

       

      and this is the new table I created 

      and this is the measure created

      MV =
      switch (
          true(),
          SELECTEDVALUE('Table'[Column1]) = "1M" && SELECTEDVALUE('Table'[Column2]) = "MV",
      CALCULATE(SUM(Sheet1[MV]),
      Sheet1[Period]= "1M"),
        SELECTEDVALUE('Table'[Column1]) = "1M" && SELECTEDVALUE('Table'[Column2]) = "Benchmark",
      CALCULATE(SUM(Sheet1[MV]),
      Sheet1[Period]= "1M"),

      SELECTEDVALUE('Table'[Column1]) = "3M" && SELECTEDVALUE('Table'[Column2]) = "MV",
      CALCULATE(SUM(Sheet1[MV]),
      Sheet1[Period]= "3M"),
      SELECTEDVALUE('Table'[Column1]) = "6M" && SELECTEDVALUE('Table'[Column2]) = "MV",
      CALCULATE(SUM(Sheet1[MV]),
      Sheet1[Period]= "6M"),
      SELECTEDVALUE('Table'[Column1]) = "1Y" && SELECTEDVALUE('Table'[Column2]) = "MV",
      CALCULATE(SUM(Sheet1[MV]),
      Sheet1[Period]= "1Y"),
      SELECTEDVALUE('Table'[Column1]) = "3Y" && SELECTEDVALUE('Table'[Column2]) = "MV",
      CALCULATE(SUM(Sheet1[MV]),
      Sheet1[Period]= "3Y")
      )

      and created relation b/w period and column many to many bi-directional.

      period for 1M not showing beacause for period IM it should display both MV and benchmark for remaining it should display only MV.

       

      • Ritaf1983's avatar
        Ritaf1983
        Icon for Super User rankSuper User
        2 years ago

        can you please save the PBIX on some drive and share the link?