Dynamic Chart based on Variable field

Hi Anonymous

Assume your fact table as below

add columns in the pie chart as above, go to "Format" pane, turn on "details label", select "Data value" for "Label style", in this way it show amount values instead of name of the field "IMC YTD".

create measures in fact table

Measure = SELECTEDVALUE('KPI'[KPI])&" "&SELECTEDVALUE(Period[Period])

Measure 2 = IF([Measure]=MAX('FACT'[Merged]),1,0)

remove all columns from the table visual but keep "merged" column

then add [Measure2] in the visual level filter in the table visual, select "show items when value is 1"

click on the cell on the table visual

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.