How to create a table without repeating common values and apply conditional formatting.

[Anonymous]

Hi All,

I have recently started working in Power BI. I have to create a table without repeating common values. I checked this can be achieved by creating a matrix. But the issue i am facing right now is it is not allow me to apply the conditional formatting.

Please see the image below for reference.

[Anonymous]

https://docs.microsoft.com/en-us/power-bi/developer/visuals/dataview-mappings#matrix-data-mapping

Matrix data mapping to make your data as hierarchy (parent-child).

https://microsoft.github.io/PowerBI-visuals/docs/concepts/objects-and-properties/#selector

you can save your setting in each row to calculate your condition