jia_han_yeoh's avatar
jia_han_yeoh
New Member
2 years ago
Status:
Needs Votes

Getting Field Parameter Filter

Hi,

 

I have created field parameter based on Region.

While display the field parameter Region from the slicer, my heatmap show Greater China, Europe and USA.

Is there any DAX able to capture the heatmap info while user click on it?

For Example user clicked on USA only from heatmap and I would like to show USA.

 

Groupby_selection = {

  ("Region", NAMEOF('fact_table'[region]), 0),

  ("Country", NAMEOF('fact_table'[country]), 1),

  ("Division", NAMEOF('fact_table'[division]), 3)

 

I am using this DAX to capture the heatmap filter

CONCATENATEX(VALUES( Groupby_selection[Parameter Fields]),Groupby_selection[Parameter Fields],",")

however it shows me 

'fact_table'[region] instead of USA.


Please find the full details below:

https://community.fabric.microsoft.com/t5/Desktop/Getting-Field-Parameter-Filter/m-p/3581006#M1177962

Recent ideas