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.
Here's a template dataset:
(PBI file: categorysales.pbix)
Next, I put it into a column chart to see total sales per month:
If I want to see how well each of the categories are performing for each month, a column and line chart by default does not work:
What is possible is creating measures per category and adding it to the Line Values:
Bikemeasure = CALCULATE(SUM(Table1[Profit]), Table1[Category] = "Bike")
I can add one for each category, and add them to the chart and get the results I want:
asd
This gets the job done, but in a real-life dataset, I will end up with quite a few measures (X columns * Y types).
Is there a better way than this? Can variables be used within the measure, so that I end up with only one measure per column?
hi, @Anonymous
To my knowledge, the "lenged" column only affects the columns in a combo chart in power bi for now.
So for your requirement, there are two workaround for you refer to:
1. As you said, create different measure for each category and then drag them in Line values.
2. Exchange Line values and Column values, and then drag category into column series.
Regards,
Lin
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 |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |