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
2 Comments
- fbcideas_migusrNew MemberStatus added:New
- jeroenterheerdtMicrosoft EmployeeStatus changed:NewtoNeeds Votes
Recent ideas
Deployment pipeline: Deployment rules for Direct Lake on OneLake semantic models
Currently, it is not possible to use deployment rules with Direct Lake on OneLake semantic models. The option is greyed out. Please enable this, so we can automatically change the data so...frithjof_v1 hour agoCommunity ChampionNew6KViews137likes17CommentsNative Master Data Management Solution
Microsoft Fabric currently lacks a native Master Data Management (MDM) capability, creating a gap for organizations that need to manage and govern business-critical reference data such as customers, ...bradcoles2 hours agoRegular VisitorNew212Views1like3CommentsCopy results as markdown from data grid
When copying results from a query on the SQL Endpoint or Data Warehouse I often have to convert from the tab delimited table to markdown for sharing the results via services like teams or github. It...Tom_Fosterbi3 hours agoRegular VisitorNew6Views0likes0Comments