How to add slicer by Column?

[ad544935592]

Hi All,

I am new to Power BI. I have some specific requirement which I would like to explain to you.

I have these columns FY17 Sales, FY17 Gross Margin, FY18 BUDGET Sales, FY18 BUDGET Gross Margin and FY18 Forecast Sales, FY18 Forecast Gross Margin.

What my requirement is 1) I want to add slicer for sales and Gross Margin. So if I select Sales I will have sales of all the year FY17 Sales, FY18 Budget Sales and FY18 Forecast Sales and same goes with gross Margin 

2) And I want to add other slicer for FY17, FY18 Budget and FY18 Forecast, so for example of I select FY17 i will get the data of FY17 sales, FY17 Gross Margin and same with FY18 Budget and Fy18 Forecast.

I hope you will gonna help me out here, this is really crucial for me.

Thanks a lot.

[Greg_Deckler · Accepted solution]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490