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 community
I have a calendar table which permit me to filter year and month
I want to show in a table the sum of my production per month.
If i select may 2023, i would like this result
January 2023 : result
February 2023 : result....
....
May 2023 : result ...
Thx in advance
Solved! Go to Solution.
Hi @nasolme ,
I am not sure If I get the question correctly since this should be quite straight-forward.
So you need only two things:
1. Have a filter/slicer for years
2. Use your Month-Year column in the visuals.
The moment you use filter or slicer the results will appear.
Of course be sure that you have an active relationship between your Calendar table and Fact table.
Hi @nasolme ,
I am not sure If I get the question correctly since this should be quite straight-forward.
So you need only two things:
1. Have a filter/slicer for years
2. Use your Month-Year column in the visuals.
The moment you use filter or slicer the results will appear.
Of course be sure that you have an active relationship between your Calendar table and Fact table.
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 |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |