Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Not sure if this is possible, but looking for a line graph where I will have multiple lines each representing the values for different dates for a comparison purposes.
E.g. My data would look like this. I want to have two separate date slicers (daily update) for two different lines: one is for the most current date forecast and the other is the choice of select. For example, I want to compare 4/3/2021 forecast against any other date's forecast (e.g. 4/1/2021) with projection years as my X axis. Any help would be appreciated!
Daily Update | Projection Year | Forecast |
4/1/2021 | 2021 | $ 55 |
4/1/2021 | 2022 | $ 65 |
4/1/2021 | 2023 | $ 75 |
4/2/2021 | 2021 | $ 56 |
4/2/2021 | 2022 | $ 66 |
4/2/2021 | 2023 | $ 76 |
4/3/2021 | 2021 | $ 57 |
4/3/2021 | 2022 | $ 67 |
4/3/2021 | 2023 | $ 77 |
Solved! Go to Solution.
@muhitdinfa1 , Based on what I got
Refer to my blog if that can help
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
@muhitdinfa1 , Based on what I got
Refer to my blog if that can help
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |