Forum Discussion
Looking for some layout structure/ideas/guidance please
- 10 months ago
I didn't understand the intent of your question.
If you select one option in the Service_Name slicer, the options in the other slicers will be automatically narrowed down to the options showed below.For your reference.
- Anonymous10 months ago
Hi RichOB
Thank you for reaching out to the Microsoft Fabric Forum Community.
mickey64 Thank you so much for the inputs.
The information provided by the user is helpful, and additionally : You can make the dashboard automatically change visuals based on the Service Name by linking each service to its Service Type.
When a user selects a service (like Brighton_1), Power BI automatically filters the data to that service type (like HR) and shows visuals designed for it, such as a bar chart, table, or gauge. To do this, create a slicer for Service Name, build separate visuals for each Service Type, and save bookmarks that show or hide visuals depending on the type. Then, use a DAX measure like Selected Service Type = SELECTEDVALUE('Table'[Service_Type]) to detect which type is selected and use it with bookmarks or page navigation so Power BI displays the right layout automatically.
If you have many services, it’s often easier to create one page per Service Type (like HR, IT, or Marketing) and let users be directed to the correct page when they select their Service Name.If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Thanks.
Hi mickey64 thanks for your info, I'll explain using your reply.
If I worked in Brighton_2 and clicked that option in the silcer, it changes to the table data that you created. Then my colleague who works in Manchester_1 needs to see their data, but they need to see it in line graphs, bar charts and a pir chart. How can the service_name dictate the different visuals changing entirely?
In my real-life example, I've got 150 services and 9 service types. Can bookmarks be attached to a service type to dictate the different graph changes?