Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Column and Line Chart with multiple lines from one column

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 ...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

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