Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there ,
I have a data as below ;
When i create a chart on power bi , datas are showed together based on months as below
But i want to show datas as below based on their names groupped first then based on month , could you pls telll me how can i manage below seem on power bi ... thanks in advance
Solved! Go to Solution.
I was hoping Field Parameters could be used to quickly solve this but the result wasn't quite what you requested. Instead I put your Categories into a table and added a measure to extract the values from your table.
1. Category table (DAX), Seq should be used as sorting column:
Categories = DATATABLE(
"Category", STRING,
"Seq", INTEGER,
{
{"Total Sales", 1},
{"Branch 1 Sales", 2},
{"Branch 2 Sales", 3},
{"Total Order Qty", 4},
{"Total Delivery", 5},
{"File Qty", 6}
}
)
2. Measure (DAX):
Measure = SWITCH(SELECTEDVALUE(Categories[Category]),
"Total Sales", SUM('Table'[Total Sales]),
"Branch 1 Sales", SUM('Table'[Branch 1 Sales]),
"Branch 2 Sales", SUM('Table'[Branch 2 Sales]),
"Total Order Qty", SUM('Table'[Total Order Qty]),
"Total Delivery", SUM('Table'[Total Delivery]),
"File Qty", SUM('Table'[File Qty])
)
3. Use Clustered Column Chart visual with 'Categories'[Category] as x-axis, 'Categories'[Measure] as y-axis and 'Table'[Month] as legend.
I was hoping Field Parameters could be used to quickly solve this but the result wasn't quite what you requested. Instead I put your Categories into a table and added a measure to extract the values from your table.
1. Category table (DAX), Seq should be used as sorting column:
Categories = DATATABLE(
"Category", STRING,
"Seq", INTEGER,
{
{"Total Sales", 1},
{"Branch 1 Sales", 2},
{"Branch 2 Sales", 3},
{"Total Order Qty", 4},
{"Total Delivery", 5},
{"File Qty", 6}
}
)
2. Measure (DAX):
Measure = SWITCH(SELECTEDVALUE(Categories[Category]),
"Total Sales", SUM('Table'[Total Sales]),
"Branch 1 Sales", SUM('Table'[Branch 1 Sales]),
"Branch 2 Sales", SUM('Table'[Branch 2 Sales]),
"Total Order Qty", SUM('Table'[Total Order Qty]),
"Total Delivery", SUM('Table'[Total Delivery]),
"File Qty", SUM('Table'[File Qty])
)
3. Use Clustered Column Chart visual with 'Categories'[Category] as x-axis, 'Categories'[Measure] as y-axis and 'Table'[Month] as legend.
In Power Query, if you select the first column (Date?) and choose Unpivot other columns, you will get 3 columns that can be pulled on to a column chart to get what you want
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |