Forum Discussion

Othman's avatar
Othman
Icon for Helper I rankHelper I
4 years ago

2 Slicers in 1 Line Chart

Hello,   https://www.dropbox.com/s/8ignco9rpwq3crl/2%20slicers%201%20Line%20chart.pbix?dl=0   I uploaded my PBI file, I would like ask if its possible to select two quarters from a slicer to show...
Need Help
v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Othman , 

Is that you want to add another two lines in the chart?

if yes, the following show is it you want ?

To reach this, drag quarters flied in the legend of line chart

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Othman's avatar
Othman
Icon for Helper I rankHelper I
4 years ago

I already have "scenario" in the Legend. If I replace it with "quarter" data, it will give me the data with both scenarios "Base/S4" combined fo each quarter, rather than 2 seperate lines.

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Othman, It is hard to reach that, I think this maybe you want

    I had create a column via this expression:

    Column = [quarter]&[scenario]

    and replease it for "scenario" in the Legend.