Forum Discussion

lisampederson's avatar
lisampederson
Icon for Helper I rankHelper I
8 years ago
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...
Need Help
  • lisampederson's avatar
    lisampederson
    8 years ago

    v-yuta-msft

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

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

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