Getting Field Parameter Filter

[batmanforever]

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

[Anonymous]

Hi @batmanforever ,

As @lbendlin  said, it's currently unavailable. 

It is recommended that you try to unpivot columns in Power Query, and turn the three region columns into one column as attributes.

Unpivot columns - Power Query | Microsoft Learn

Best Regards,

Stephen Tao

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

[lbendlin]

not currently possible. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41