Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Okay, I have searched the forums to no avail and I feel what I am looking for is pretty simple. I have all the YTD, QTD, MTD, YOY, etc. calculations working correctly in a table but when it comes to a bar chart, I am not getting the desired results.
I have a year and month slicer. User can only make 1 selection for each slicer. It works great with the table, but not for the charts.
When a user selects the year and month, I would like each chart to show all revenue up to the current month, quarter, year. For example, If the user selects Augst in the month slicer:
Ideally, I would like to show the prior year up to the month selected in the month slicer.
Can someone please help me out on this?
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
111 | |
104 | |
85 | |
65 | |
63 |