Combine "Fields" so Visualization can reference data set

[lisampederson]

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

[v-yuta-msft]

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

[lisampederson · Accepted solution]

@v-yuta-msft

I couldn't figure out how to do that.  I tried the UNION function and it worked.

[lisampederson]

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

[lisampederson]

Link: See link here