Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Good day!
Can someone help me how I can do this? Like I have a data in a column which I want to show in a matrix here is example:
Best Regards,
Ran
Solved! Go to Solution.
Hi @RanHo
Your data is incomplete. You need to add a 'Date' and 'Type' column to the dataset. Like so:
For the MonthSort column, first click on 'Date' column and choose 'Date' data type, then click 'Add new column' and type:
MonthSort = MONTH([Date])
After, you need to click on Month column and choose Sort By Column - 'MonthSort'.
Then when your dataset is ready, put 'Month' in Rows, 'Type' in Columns and 'Product' in Values, then click the down arrow on Products and choose count.
End result:
Hi @RanHo ,
I guess a month/date column is missing from the table.
Put month column in Row and products column in Column.
Then create a slicer by using farm column.
Best Regards,
Jay
Hi @RanHo
Your data is incomplete. You need to add a 'Date' and 'Type' column to the dataset. Like so:
For the MonthSort column, first click on 'Date' column and choose 'Date' data type, then click 'Add new column' and type:
MonthSort = MONTH([Date])
After, you need to click on Month column and choose Sort By Column - 'MonthSort'.
Then when your dataset is ready, put 'Month' in Rows, 'Type' in Columns and 'Product' in Values, then click the down arrow on Products and choose count.
End result:
Hi @RanHo
Paste some sample data...
Proud to be a Super User! | |
@RanHo , Matrix visual
Product on column
Month on row
and Farm in slicer
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |