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,
I have a table like above:
Period | Team | Country | Users count | Usage count |
2019-02 | ZA | IT | 10 | 5 |
2019-03 | MPM | UK | 3 | 2 |
2019-03 | TDC | US | 4 | 1 |
2019-04 | ZC | FR | 8 | 3 |
2020-03 | ... | ... | ... | ... |
I want to compute those results with two segments over YEAR and over QUARTER with a switch QUARTER TO MONTH like below.
With the Quarter switch active:
Witch the month switch active:
The selections have to modify the whole table values.
How can i perform it efficiently ?
Hi, @Anonymous
Please correct me if I wrongly understood your question.
the first step is to create slicers: Year, Quarters, Months
the second step is to create buttons: Quarter, Month -> by clicking one of those, it will hide or show the corresponding slicer.
If you have a sample pbix file, please share and I can try to come up with desirable solution.
Thank you.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
39 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |