Forum Discussion
Reference the field parameter in dax measures to dynamically change the visuals
Hi,
My requirement is to use columns from field parameter to dynamically change the visual
Field parameter table is as below:
The columns Category, Category Main are calculated columns that are used in slicer buttons in visual.
Now what I want to achieve is, when I click the Target button, and Units or cost I should have corresponding values dynamically selected in the below visual. Similarly when i select the Budget Cost/Units it should change the visual.
The line Y-axis of the above visual works perfectly as brought in the Parameter directly. But for column y-axis I have two things to be taken care of
i)Actual
ii)Forecast
I had tried to tweak the forecast measure but its not dynamically changing the values, The forecast measure consist of 2 measures (preforecast & forecast)
---------
Thanks in advance!
Ahmedx amitchandak Greg_Deckler Ashish_Mathur Anonymous marcorusso
sivarajan21 , I have made some changes in the file, check if those can help -https://www.dropbox.com/scl/fi/adaijt0nwzlg2t3nxizrz/Portfolio-6-latest.pbix?rlkey=uqkf4kfdeney8eu9ky4jdsgei&dl=0
2 Replies
- amitchandak
Super User
sivarajan21 , I have made some changes in the file, check if those can help -https://www.dropbox.com/scl/fi/adaijt0nwzlg2t3nxizrz/Portfolio-6-latest.pbix?rlkey=uqkf4kfdeney8eu9ky4jdsgei&dl=0
- sivarajan21
Post Prodigy
Hi amitchandak
Apologise for the delay!
Thanks for your quick and amazing solution!😊
This is working like a gem!
I will accept this as a solution and close this thread!