Forum Discussion

batmanforever's avatar
batmanforever
Regular Visitor
2 years ago

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 help

2 Replies