Measures are in Slicer Visual

[Prakash1050]

Hi All, 

      I have two DAX Measures and These measures are put into the slicer visual. It is Possible to show these measures in Slicer Visual.

      If it is possible how to do this scenario.

      Please help me.

      Thanks in advance.

[HarishKM · Accepted solution]

@Prakash1050 Hello Prakash,
Create a disconnected table and use Switch measure to fulfill your requirement.
Kindly refer below image.

step 1 : Select enter data 

step 2 : feed data for slicer like slicer name and sorting order 

step 3: Drag that newly created slicer table to slicer 

step 4: Now write a dax like this

Measure = SWITCH(TRUE(),

SELECTEDVALUE(Slicer[Type])="OAS Pre",1,

SELECTEDVALUE(Slicer[Type])="OAS Past",2,

SELECTEDVALUE(Slicer[Type])="OAS",3,

"need to select a slicer")

Then you can select the slicer to see the value.

Thanks

Harish M

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Prakash1050]

Hi @HarishKM ,

            It's Worked Bro.

            I need exact this scenario.

            Thank you so much

[v-zhangti]

Hi, @Prakash1050 

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Prakash1050]

Hi @v-zhangti ,

         Thanks for Youre response.

           The first visual is Table and the columns are DAX Measure.

           The second visual is Slicer.

           I need to put the all these DAX Measures in Slicer Visual.

           Can you help me.

[v-zhangti]

Hi, @Prakash1050 

There is no way to put the measure directly into the slicer in your case. You can try the following methods.

Example data:

New Slicer table:

New table = UNION(
    SUMMARIZE('Table',"1",[Measure1]),
    SUMMARIZE('Table',"2",[Measure2]),
    SUMMARIZE('Table',"3",[Measure3]),
    SUMMARIZE('Table',"4",[Measure4]))

If you have further ideas, you can share them.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Prakash1050]

Hi @v-zhangti , 

          This is good.

          But i need to show the measure names in slicer after that i clicked any measure name that values are showing another card visuals.

          It is possible?