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 Team,
The seems to be simple but I am not able to solve it. Here it is
I need 2 buttons.
1. is to show completed months
2. to show data till date.
example:
If I press "Completed Months" button then data should show only completed months i.e is till last month
If I press "Current Month" button then data should show till date. i.e is from the begining to till date.
Regard
Drake
Solved! Go to Solution.
Hi
Managed to workout myself, I have created a slicer with current month and completed month and now everything depends on Slicer selection, Manager accepted it. I am happy.
Regards
Hi
Managed to workout myself, I have created a slicer with current month and completed month and now everything depends on Slicer selection, Manager accepted it. I am happy.
Regards
You can create a column in your date table to calculate the current fullfilled month.
e.g. I use a filter to select a month: Full month = IF(MONTH(TODAY())-1=Month[Month];"Current Reporting Period";Month[Month])
Then use the month in your YtD measure.
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 |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |