Forum Discussion
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 visualization works for one project. However, I want the data in my visualization to change based on which project is selected in the filter. My data file has tabs for each project. Is there a way to make the visualization reference this file instead of an individual project tab?
Please see the attachment for my data. Thank you!
Lisa
I couldn't figure out how to do that. I tried the UNION function and it worked.
4 Replies
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.
Thanks for the reply. I'll try that. Sorry I didn't realize my link didn't work. Here's the new link:
https://www.dropbox.com/s/4sl1626sjemagtt/SAMPLE%20POWERBI%20Unit%20Cost%20Tracking.xlsx?dl=0
