Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi all, I am still new and learning powerBI so please be kind.. 🙂
I am creating some visuals for the local fire department. I am looking at the distribution of events by shift time, and as well by day of week and month. the only way i could do this was to create two charts, one with shift time and month and the other with shift time and day of week. I would also like to see the distribution of each YOY, but again i need to create a 3rd chart to see what i want.
Is there a way, i think using parameters (based on my google searches) that i can allow the user to decide what they want to see, and have one single chart? My initial try with parameters didnt give me what i wanted.
The images attached are my initial page with my 2 charts, and the second is what i would want things to look like YOY, after selecting a single month in the slicer. I want to be able to have the user select what they want to see in a single chart - shift time, month or day of week, and YOY if they so choose.
Thanks in advance!
Mike
Solved! Go to Solution.
Hi @mikegrad77
Have you tried using Modelling -> New Parameter -> Fields
You can have a slicer for your categories and another for the KPIs
Check this video at 08:40 to see if its what you want: Ultimate Dynamic Visual - Power BI (youtube.com)
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Hi @mikegrad77
Have you tried using Modelling -> New Parameter -> Fields
You can have a slicer for your categories and another for the KPIs
Check this video at 08:40 to see if its what you want: Ultimate Dynamic Visual - Power BI (youtube.com)
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
this worked, but of course now i have a new issue. i'm halfway there.. 🙂
i havent tried this specific thing - ill give it a shot and come back!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
89 | |
84 | |
76 | |
64 |
User | Count |
---|---|
135 | |
112 | |
98 | |
98 | |
92 |