Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
mikegrad77
Regular Visitor

question on creating dynamic visual for the axis?

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!

MikeScreenshot 2024-08-09 074335.jpgScreenshot 2024-08-09 074437.jpg

1 ACCEPTED SOLUTION
SamWiseOwl
Community Champion
Community Champion

Hi @mikegrad77 

Have you tried using Modelling -> New Parameter -> Fields
You can have a slicer for your categories and another for the KPIs

SamWiseOwl_0-1723205354860.pngSamWiseOwl_1-1723205361394.pngSamWiseOwl_2-1723205392279.png

 

Check this video at 08:40 to see if its what you want: Ultimate Dynamic Visual - Power BI (youtube.com)

SamWiseOwl_3-1723205526471.png

 


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.

View solution in original post

3 REPLIES 3
SamWiseOwl
Community Champion
Community Champion

Hi @mikegrad77 

Have you tried using Modelling -> New Parameter -> Fields
You can have a slicer for your categories and another for the KPIs

SamWiseOwl_0-1723205354860.pngSamWiseOwl_1-1723205361394.pngSamWiseOwl_2-1723205392279.png

 

Check this video at 08:40 to see if its what you want: Ultimate Dynamic Visual - Power BI (youtube.com)

SamWiseOwl_3-1723205526471.png

 


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!

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.