Can someone share some thoughts if below is doable or not?
I wanted to create a report with 6 visuals and a slicer with 30 measure names(only names of measures not measure itself).
Task 1
On selection of one measure name from slicer first visual will show that measure. This part is done as I am able to display visual on the basis of user selection. ( in case of radio button, when only one option can be selected )
I used below measures to toggle selected choice by user
This measure to find what user has selected from slicer ( only works for single selection not mulitple )
[SelectedMeasureFromList] =
SWITCH( TRUE(),
[MeasureSelected] = "Volume",[Volume],
[MeasureSelected] = "Revenue",[TotalRevenue],
[MeasureSelected] = "Cost",[TotalCost],
[MeasureSelected] = "Pure Margin",[TotalPureMargin],
[MeasureSelected] = "ARPU",[ARPU],
[MeasureSelected] = "AMPU",[AMPU],
[MeasureSelected] = "ACPU",[ACPU],
BLANK() )
This measure is used to find which measure to use to display in visual
[DisplayThisSelectedMeasure] = SELECTEDVALUE(SelectedMeasureFromList[Measure],[AMPU])
Task 2
Restrict users to select fixed number of choices from slicer, like 6 in this case? I am not able find that option?
Task 3
Upon user selection of 6 measures, all 6 visuals display those selected measures from slicer? For this task I am not able to find a way to store names of selected choices by user as they are more than one? In programming languages we use Strings where location 0, location1 .. location 5 will be stored and then used accordingly? Does that make sense and Doable?
Your input will be crucial for my application development, plesae share your thoughts.
Regards
Ali
