Forum Discussion

pradeept's avatar
pradeept
Resolver I
5 years ago

Dynamic Label in Title

Hi,   Need help in dynamic labeling.   Scenario:  In one page i created 4 charts, with different dimensions(Top 3). I want to toggle between the metrics, across all the 4 charts.  accordingly ti...
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
5 years ago

1. Create two Dax Measures for State and Product 

  • StateMeasure  = If( SELECTEDVALUE(Table[Category]) = "SalesAmount" , "Sales Amount", SELECTEDVALUE(Table[Category])) & " by State"
  • ProductMeasure  = If( SELECTEDVALUE(Table[Category]) = "SalesAmount" , "Sales Amount", SELECTEDVALUE(Table[Category])) & " by Product"

2. Select the visual and go to format pane and enable Title and Click on "fx"  and follow as per below screenshot