Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Customize Matrix Visual to have same look and feel as table

Hello,

 

I have this table in excel, would be possible to achieve the same result in Power BI with matrix visual or any other visual:
In one part I have the date sliced by states ("Formalizadas", "En Curso") and by the measures ("Operaciones, "Var", "Importe"...etc)
in rows I have the products. But the measures "% Formalización" "%Abandono" "%Cancelado" which are on the right of the table I don´t want them sliced neither by day/mtd neither by state.

I tried to have replicate the same of look of feel with matrix visual but I was not able to achieve it (the % measures not sliced by states or date). Also the column headers I can only have one particular color.
How could I achieve the same wether with these visual or other the same look & feel as the  table above?

Example trying to replicate table above with matrix visual in power BI




  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, Anonymous 

    The current version of Power BI Desktop does not support the effect you are trying to achieve (only Calculated Column can be used as a column, and in the case of Measure, it is automatically grouped based on the fields in the column). You can submit an idea for here and the product team will take note of such a need.

    Related Link: New tab (powerbi.com)

    Best Regards,
    Yang

    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know.
    Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, Anonymous 

    The current version of Power BI Desktop does not support the effect you are trying to achieve (only Calculated Column can be used as a column, and in the case of Measure, it is automatically grouped based on the fields in the column). You can submit an idea for here and the product team will take note of such a need.

    Related Link: New tab (powerbi.com)

    Best Regards,
    Yang

    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know.
    Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, Anonymous 

    Happy to help, you can share pbix files or data table without sensitive data for testing.

    Best Regards,
    Yang

    Community Support Team

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous, I´ve shared via private message the link to the file. It was dummy data.

    Thank you.