Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone
I can't create this simple chart in PowerBI that I've used in Excel for years.
I created cumulative sales to use on the lines, however cumulative appears as sum of 2016 and 2017 (see below), as opposed to two different lines for each year.
Thank you in advance!
Petek
Solved! Go to Solution.
HI @pvural,
Based on test, current 'Line and Clustered Column chart' not support auto analysis your measure and generate multiple lines of each category.
For your requirement, you need to manually write multiple measures for each category or try to submit it to ideas forum.
BTW, if you switch your visual to matrix, it can drill your measure to each categories.
Regards,
Xiaoxin Sheng
HI @pvural,
Based on test, current 'Line and Clustered Column chart' not support auto analysis your measure and generate multiple lines of each category.
For your requirement, you need to manually write multiple measures for each category or try to submit it to ideas forum.
BTW, if you switch your visual to matrix, it can drill your measure to each categories.
Regards,
Xiaoxin Sheng
Hello @v-shex-msft
I accepted your multiple measure offer as the solution. Just adding the year specific DAX for those who are interested.
2019 Gross Sales (YTD) = CALCULATE(SUM(YourTable[GrossSales]),FILTER(Date,Date[Year]=2019))
Best regards,
Petek
Thank you for taking the time to respond. It is a little bit frustrating when you can not duplicate simple things you do in Excel.
Regards,
Petek
Hi @pvural,
>>It is a little bit frustrating when you can not duplicate simple things you do in Excel.
Yes, current there are some differences between excel dax formula and power bi dax formula. They all has the specific functions which only work on themselves.
Regards,
Xiaoxin Sheng
User | Count |
---|---|
98 | |
90 | |
82 | |
70 | |
67 |
User | Count |
---|---|
115 | |
104 | |
101 | |
72 | |
64 |