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 am putting together a line Graph of Current year, PY and Budget sales.
To get this, I have to combine two different Tables.
Table1 Includes Full budget, full 2019 and Jan - April 2020
Table 2 includes 2019 - up to today 2020. The data is just missing specific entries, so the sales do not match up. Thats why I must use table1 for previous sales.
For 2020 I would like to add the Table 1 sales plus table 2 2020 sales for Period 5 only.
Formula Used to combine the data is
My goal is to show 2020 Period 1 -5 on this line graph (specifically a line and cluster, but only using the line)
Thank you for your help
Hi @Anonymous ,
It seems like you use the month hierarchy in the axis and your measure like [Table1 GSV20] has quoted whole values about 2019 so that it will reflect in the line chart.
One way to solve this is use the visual filter to just show only 5 months in line chart.
Or could you please consider sharing your measure or a dummy .pbix file for further discussion?
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
I'm having trouble visualizing this. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Thank you I editied to be a bit clearer and show formula and chart.
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |