Forum Discussion

DarshanKumar's avatar
DarshanKumar
Helper II
1 year ago
Solved

Multiple Button Bookmarks - Need Help

Hi,   I have a requirement to show the attrition in a matrix visual for last 12 months and year to date, I was able to achieve this using bookmarks, now I have additonal requirement to show the  le...
Need Help
  • v-achippa's avatar
    v-achippa
    1 year ago

    Hi DarshanKumar,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Based on your requirement, please follow below steps:

    • Create two independent tables:

      PeriodSelector = DATATABLE("Period", STRING, {{"YTD"}, {"LTM"}})

      MetricSelector = DATATABLE("Metric", STRING, {{"Headcount"}, {"Attrition"}})

    Add these both tables to the report as slicers and format them as buttons.

     

    • Create a new measure like below:

      SelectedMetricMeasure =

      VAR _Metric = SELECTEDVALUE(MetricSelector[Metric])

      VAR _Period = SELECTEDVALUE(PeriodSelector[Period])

      RETURN

          SWITCH(

              TRUE(),

              _Metric = "Headcount" && _Period = "YTD", [Headcount_YTD],

              _Metric = "Headcount" && _Period = "LTM", [Headcount_LTM],

              _Metric = "Attrition" && _Period = "YTD", [Attrition_YTD],

              _Metric = "Attrition" && _Period = "LTM", [Attrition_LTM],

              BLANK()

          )

    Use this measure in the matrix visual, the data will update automatically based on both slicer selections.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa

pankajnamekar25's avatar
pankajnamekar25
Super User
1 year ago

Hello DarshanKumar 

Try this

 Create a Field Parameter for Metrics:

Go to Modeling → New Parameter → Fields.

Name it MetricSelector

Add fields like:

Headcount_YTD

Headcount_LTM

Attrition_YTD

Attrition_LTM

 Create a Slicer using MetricSelector

Style it as buttons or drop-down.

Use MetricSelector in the Matrix Values

The matrix will update based on the selection.

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.