Table Visual in power BI

[Jos13]

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

[FarhanAhmed · Accepted solution]

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 · Accepted solution]

@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

[FarhanAhmed · Accepted solution]

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.

[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...

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.