Need help with Matrix Visual

[Jos13]

Hi All,

I have the following data.

I need the below visual in power bi

For columns like Offline, Online and All Site, we count for "Yes"(Created measures for them).

Please guide me if this is possible in power bi.

[Anand24]

Hi @Jos13 ,

PFA solution. You can achieve your result using matrix and calculaed measures for each type.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[PaulDBrown]

@Jos13 

Check out this blog post and see if it helps:

Creating a hybrid or custom matrix 

[amitchandak]

@Jos13 , Create two measure A and B and use

A= countx(filter(Table, Table[status] ="A"),[status])

B= countx(filter(Table, Table[status] ="B"),[status])

for other

offline =countx(filter(Table, Table[offline] ="Yes"),[offline])

do for online an all

[Jos13]

Can we skip creating measures for the column Status ?. This column might get new values in the future and I want to show them dynamically in the visual. I tried adding the Status column to the Columns area. But it is not giving the result as expected.

[amitchandak]

@Jos13 , I suggested all measures

if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc