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 have yearly budget/forecast data, and we have a new version every 3 months. For example,
Year, Version, Amount
2021, 20-11, $1200
2021, 21-02, $1000
2021, 21-05, $1100
And I want users to choose two versions and display the differences in a bar chart. It would be great if the users can choose versions using slicers but I dont know if that is possible.
If there are ways other than using slicers then that works too.
Solved! Go to Solution.
Hi @hideakisuzuki01 ,
You can create two new slicer table:
slicer1 = SELECTCOLUMNS('Table',"Year",'Table'[Year],"Version",'Table'[Version])
slicer2 = slicer1
Then you can create two measure:
Measure = CALCULATE(SUM('Table'[Amount]),FILTER('Table','Table'[Version] in VALUES(slicer2[Version])))
Measure1 = CALCULATE(SUM('Table'[Amount]),FILTER('Table','Table'[Version] in VALUES(slicer1[Version])))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @hideakisuzuki01 ,
You can create two new slicer table:
slicer1 = SELECTCOLUMNS('Table',"Year",'Table'[Year],"Version",'Table'[Version])
slicer2 = slicer1
Then you can create two measure:
Measure = CALCULATE(SUM('Table'[Amount]),FILTER('Table','Table'[Version] in VALUES(slicer2[Version])))
Measure1 = CALCULATE(SUM('Table'[Amount]),FILTER('Table','Table'[Version] in VALUES(slicer1[Version])))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
@hideakisuzuki01 , In this case, you need two independent tables with version or version and year. Then you need to use them to filter data to compare.
refer to my date range blog on a similar topic
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
New table 1 = summarize(Table, [Year], [Version])
New table 2 = summarize(Table, [Year], [Version])
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |