Forum Discussion
Post PartisanLooking for some layout structure/ideas/guidance please
Hi, in this scenario, I have 1 data set in the table below. Each service is tied to a Service Type, and the Service Type dictates what type of KPI's are reported on. I want a dashboard layout where a Service Manager can click their Service_Name, and the KPI_Type visuals will change to what they relate to from the Service Type. I don't want the Service Manager to have to click HR, IT or Marketing; I need the Service Name to automatically do this. Here's the table data:
| Service_Name | Service_Type | KPI_Type | Total |
| Brighton_1 | HR | Grievances | 5 |
| Brighton_1 | HR | Leaver Count | 3 |
| Brighton_1 | HR | Applicants | 22 |
| Brighton_2 | HR | Grievances | 9 |
| Brighton_2 | HR | Leaver Count | 5 |
| Brighton_2 | HR | Applicants | 33 |
| London_1 | HR | Grievances | 4 |
| London_1 | HR | Leaver Count | 8 |
| London_1 | HR | Applicants | 44 |
| Manchester_1 | IT | Response Time | 3 |
| Manchester_1 | IT | Tickets Solved | 12 |
| Manchester_2 | IT | Response Time | 4 |
| Manchester_2 | IT | Tickets Solved | 18 |
| Leeds_1 | Marketing | Conversion_Rate | 9 |
| Leeds_1 | Marketing | Impressions | 100 |
| Leeds_1 | Marketing | Leads | 200 |
| Newcastle_1 | Marketing | Conversion_Rate | 5 |
| Newcastle_1 | Marketing | Impressions | 120 |
| Newcastle_1 | Marketing | Leads | 300 |
Example 1
Example 2
The visual default icons are just an example of the intended change per Service_Type.
How can this be achieved, please?
Thanks
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.
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.
5 Replies
- mickey64
Super User
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.
RichOBHi 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?
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 RichOB
Thank you for reaching out to the Microsoft Fabric Forum Community.
I hope the information provided was helpful. If you still have questions, please don't hesitate to reach out to the community.
Hi RichOB
Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.