Need help of filter selections

[ramshoney1225]

Hi ,

I have a page with slicer Month ( which shows from jan to dec ) . Now I have a graph with Month on X-axis , Measure1(Bar), Meassure2(Line), Measure3(line), Measrue4(line).

Now when i select Month Jan from Slicer, then the bar measure need to show Jan Value and the remaining 4 Line meeasures need to show from Jan to December values.

My understanding is so the X-axis shows Jan - Dec, based on selection the selected Months( shows bars for that Months), for remaining 4 line measures it shows for all 12 months.

Need quick help,Thanks for the support.

[v-stephen-msft · Accepted solution]

Hi @ramshoney1225 ,

I made a simple example

Sample data is this. The index column is to sort the month by the index column.

Create a separate table by entering data. There's no relationship between two tables.

Four measure are

Measure1(Bar) = CALCULATE(SUM('Table'[Value1]),FILTER('Table',[Month] in ALLSELECTED('Table (2)'[Month])))

Meassure2(Line) = SUM('Table'[Value2])

Measure3(line) = SUM('Table'[Value3])

Measrue4(line) = SUM('Table'[Value2])+SUM('Table'[Value3])

You can check details from the attachment.

Best Regards,

Stephen Tao

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

[Tahreem24]

@ramshoney1225  you can use the Edit interaction feature to disable remaining chart's interaction off with that Month Slicer.

Step1: Select Month Slicer and go to Format Menu then click on "Edit Interaction".

Step 2: Then click on all you charts which you want all 12 months on x-axis and click on None icon like below screen shot:

[amitchandak]

@ramshoney1225 , You need to use an independent date table for that. Based on the selected date you change the date range of the measures

refer my video how to use that : https://www.youtube.com/watch?v=lOEW-YUrAbE