Forum Discussion

RichOB's avatar
RichOB
Icon for Post Partisan rankPost Partisan
10 months ago
Solved

Looking 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...
  • mickey64's avatar
    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.

  • Anonymous's avatar
    Anonymous
    10 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.