Forum Discussion
Solved
Combine "Fields" so Visualization can reference data set
Hello, I have the "Line and Custom Column Chart" visualization that shows cost data by project with month to date baseline vs actual spend, and baseline vs forecast project to date spend. The vi...
I couldn't figure out how to do that. I tried the UNION function and it worked.
Hi lisampederson,
Your link seems can't be visited with external account. In addtion, do you mean you want to change data in chart based on a slicer and the slicer is based on the [Project] column which has enabled multiple selection? If it is, you can create a measure using DAX formula like pattern below:
Result = CALCULATE ( aggregation, ALLSELECTED ( Table[Project] ) )
Regards,
Jimmy Tao
I couldn't figure out how to do that. I tried the UNION function and it worked.