Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Sakshi_S
New Member

Inverted column grid possible?

I have 3 columns as date, channel and topic of discussion and wanted to show them in a grid as below. Can you please help me know how this can be done in Power BI?

 

Sakshi_S_1-1710231356471.png

 

1 ACCEPTED SOLUTION
v-heq-msft
Community Support
Community Support

Hi @Sakshi_S ,
Based on your description, I created the following test data

vheqmsft_0-1710294333018.png

If you want to achieve the effect you want, first click on Transform data and open the power query.

vheqmsft_1-1710294444016.png

Change the name of date as date.1 and Select the date column and UNpivot the other columns.

vheqmsft_2-1710294679592.png
Close and apply and create matrix visual

vheqmsft_4-1710294814510.png

Final output

vheqmsft_5-1710294836642.png


Of course, you can also open the advance editor and enter the M code into it.

vheqmsft_6-1710294945170.png

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjTUNzTQNzIwMlbSUXJOzMkBUi6ZxamJxakKxSWJJalKsTpAVUb6hhbEqDIygqkKy0xJzceuTN8QpMgEKOlm5AYknYoS81JgUqZ45MxgcjDDobKxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t, Channel = _t, #"Topic of dicussion" = _t]),
    #"Renamed Columns" = Table.RenameColumns(Source,{{"Date", "Date.1"}}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Renamed Columns", {"Date.1"}, "Date", "Value")
in
    #"Unpivoted Other Columns"

 

 

Best regards,

Albert He

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 

 

View solution in original post

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

Create a Calendar Table with an active relationship (Many to One and Single) from the Date column of your Data Table to the Date column of the Calendar Table.  To your visual, drag Date from the Calendar Table.  Write these measures

Measure1 = min(Data[Channel])

Measure2 = min(Data[Topic of discussion])

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
v-heq-msft
Community Support
Community Support

Hi @Sakshi_S ,
Based on your description, I created the following test data

vheqmsft_0-1710294333018.png

If you want to achieve the effect you want, first click on Transform data and open the power query.

vheqmsft_1-1710294444016.png

Change the name of date as date.1 and Select the date column and UNpivot the other columns.

vheqmsft_2-1710294679592.png
Close and apply and create matrix visual

vheqmsft_4-1710294814510.png

Final output

vheqmsft_5-1710294836642.png


Of course, you can also open the advance editor and enter the M code into it.

vheqmsft_6-1710294945170.png

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjTUNzTQNzIwMlbSUXJOzMkBUi6ZxamJxakKxSWJJalKsTpAVUb6hhbEqDIygqkKy0xJzceuTN8QpMgEKOlm5AYknYoS81JgUqZ45MxgcjDDobKxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t, Channel = _t, #"Topic of dicussion" = _t]),
    #"Renamed Columns" = Table.RenameColumns(Source,{{"Date", "Date.1"}}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Renamed Columns", {"Date.1"}, "Date", "Value")
in
    #"Unpivoted Other Columns"

 

 

Best regards,

Albert He

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 

 

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors