Forum Discussion
Helper IIITable Visual in power BI
Hi all,
I have a table visual in power BI as follows:
Here table1 count and table2 count are measures and date column is from a date table.
I want the same visual in the below format :
I tried matrix visual but it is not working.
Is there a way to achieve this ?
Please find the link to pbix : https://drive.google.com/file/d/1DJ0uBLUKqDeg0lkHT1AGsnsS06Y_fjc4/view?usp=sharing
Thanks in advance
Put date in columns of matrix visual.
and measures in values
Go to Formatting tab of Matrix visual
Under values you will see the option "show on rows" you should enable this to get the desired output.
Jos13 , I think you need to use show on row. Date on Column.
refer step in
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
Please find the attached file after signature
3 Replies
FarhanAhmedCommunity Champion
Put date in columns of matrix visual.
and measures in values
Go to Formatting tab of Matrix visual
Under values you will see the option "show on rows" you should enable this to get the desired output.
- amitchandak
Super User
Jos13 , I think you need to use show on row. Date on Column.
refer step in
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
Please find the attached file after signature
- Greg_Deckler
Jos13 - To do that, you would need a disconnected table for your rows.
In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
In your case, create the disconnected table with your row values that you want. You can then use that in your matrix in the Rows area. You would craft a measure to take the MAX('DisconnectedTable'[Column]) and calculate what you want based on that.
