Slicer with Clustered Column Chart

[asjones]

I am new to Power BI (still trying to get people interested in it over Tableau) and trying to figure out a few things. I have a Clustered column chart with multiple values (bars).  I have columns for year to date (YTD) actuals, ytd budget, full year budget, prior year.  I want to have a slicer to see progress and change as it is adjusted.  However I only want the slicer to operate on certain column like YTD actuals and YTD budget and not the full year amounts or prior year amounts.

How do I do that in Power BI. I knew how to do that with Power Pivot.

thanks

Alan

[v-sihou-msft · Accepted solution]

@asjones

In Power BI Desktop, we can only limit the interaction for slicer with visuals. In this scenario, since those data fields (YTD actuals, ytd budget, full year budget, prior year) are in same clustered column chart visual, it's not possible to have slicer applied on specific data fields only. For your requirement, I suggest you separate those data fields into different chart, then "Edit Interactions" for differet chart, see: Create Complex Interactions Between Visualizations

Regards,

[BhaveshPatel]

Hi Alan,

There are quite a few ways to do this. I would suggest you to do this.

Page level filters can act as slicers. Adjusting the page level filters for those columns where you do not want the cross filtering can solve your problem.

FYI-- PowerPivot and PowerBI both have a same DAX Engine and PowerBI is evolved from PowerPivot.So if you know how to do that in  PowerPivot, It is essentilally the same calculation in PowerBI.