Customize Matrix Visual to have same look and feel as table

[jtgsoupbi]

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

[v-yaningy-msft · Accepted solution]

Hi, @jtgsoupbi 

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

[jtgsoupbi]

@Greg_Deckler @amitchandak @Ritaf1983 @MFelix @rajendraongole1 do you think this is achievable in Power BI?

[jtgsoupbi]

Hi @v-yaningy-msft, I´ve shared via private message the link to the file. It was dummy data.

Thank you.

[v-yaningy-msft]

Hi, @jtgsoupbi 

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

Best Regards,
Yang
Community Support Team