Need help with Matrix Visual

Question

Hi All,I have the following data.I need the below visual in power biFor columns like Offline, Online and All Site, we count for "Yes"(Created measures for them).&nbsp;Please guide me if this is possible in power bi.

amitchandak · Answer

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])
&nbsp;
for other
offline =countx(filter(Table, Table[offline] ="Yes"),[offline])
&nbsp;
do for online an all
&nbsp;

pauldbrown · Answer

Jos13&nbsp;
Check out this blog post and see if it helps:
Creating a hybrid or custom matrix&nbsp;

anand24 · Answer

Hi Jos13 ,
PFA solution. You can achieve your result using matrix and calculaed measures for each type.
&nbsp;

&nbsp;
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

jos13 · Answer

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 · Answer

Jos13 , I suggested all measures 
&nbsp;
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/1354591https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428
vote for Hybrid Table https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc

Forum Discussion

Need help with Matrix Visual

5 Replies

Related content

Matrix Visual Duality

Custom Matrix Visual

Power Matrix visual

Formatting Matrix Visuals

Matrix visual