Forum Discussion

porjaiko's avatar
porjaiko
Frequent Visitor
6 years ago
Solved

Need you help: Matrix visual

It's possible if i want to hide total other column and show last column only.

           follow this pic:

 

 

 

 

 

Thank you for your help.  

  • porjaiko ,

     

    In the matrix visual, the value of column/row header is not the column header in original table. You need to pivot your original table in query editor to change the values to column headers and drag specific columns to the matrix visual.

     

    Community Support Team _ Jimmy Tao

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

2 Replies

  • JarroVGIT's avatar
    JarroVGIT
    Resident Rockstar

    Few options. You can hide by placing a textbox with white back ground color over the other columns? That is the easiest way (and also the dirtiest way). Other option is to create a measure that reflects the 'total'  column and put that in a seperate matrix. 

     

    Kind regards

    Djerro123

    -------------------------------

    If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

    Kudo's are welcome 🙂

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support

    porjaiko ,

     

    In the matrix visual, the value of column/row header is not the column header in original table. You need to pivot your original table in query editor to change the values to column headers and drag specific columns to the matrix visual.

     

    Community Support Team _ Jimmy Tao

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