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.
Hello guys,
I am trying to show 2017 vs 2018 ytd cumulatives in one line chart.
My measures are correct and I can see correct figures & percentages on table.
Retail Cumulative m/m = [Cumulative YTD RETAIL]/[Cumulative YTD Total]
Cumulative YTD RETAIL = TOTALYTD(SUM(Sheet1[RETAIL.]),MasterCalendar[Date])
Cumulative YTD Total = TOTALYTD(SUM(Sheet1[TOTAL]),MasterCalendar[Date])
Problem is when I am trying to viual this in line chart.
Tope line chart is how it should look like in excel.
Botom charts are my current outcomes in BI.
Would you be so kind and help me out?
Solved! Go to Solution.
Hello @v-shex-msft,
I have manged to reslove this when I was creating exmple for you.
Thanks anyway for offering your help.
Andrej
Hi @AndrejZitnay,
Can you please share some sample data to test?
Regards,
Xiaoxin Sheng
Hello @v-shex-msft,
I have manged to reslove this when I was creating exmple for you.
Thanks anyway for offering your help.
Andrej
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 |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |