Multiple Button Bookmarks - Need Help

[DarshanKumar]

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  leavers headcount by last 12 month leavers & year to date , is there a way bookmarks can be configured to show visuals based on multipe button selection.

So the requirement is that the matrix visual should change to either attrition or headcount based on the either YTD or LTM button selection.

Regards,

Darshan

[DarshanKumar]

Thanks Pankaj.

But the requirement is show the matrix visual based on two filter. Ex

The matrix should show YTD headcount when we select YTD button and Headcount button.

I want to check if this possible if not I can have  4 buttons bookmarked to each visual Ex: HC YTD, HC LTM, Attriton YTD and Attriton LTM.

Regards,

Darshan

[v-achippa · Accepted solution]

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]

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.