Forum Discussion

DieLem's avatar
DieLem
Icon for Helper II rankHelper II
8 years ago

Filters not applying to all graphs

Good Day,   I have trouble with a filter that is not applying correctly accross both of my charts.   The file can be found here (TestBudgetDif): https://drive.google.com/drive/u/0/folders/1P10op_...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI DieLem,

 

You can try it if my sample suitable for your requirement.

I remove your visual level filter 'year month' and use two sync slicers to instead.(one to filter on monthly budget, other filter on ytd revenue) You can use sync slicers to filter on multiple pages.

 

Notice:

1. Power bi not support to return different values from single slicer.

2. Current slicer only support filter on selected value, if you want to achieve running year revenue effect, you need to use other table as 'if parameter' to return value and write a measure as filter tag to apply filter effect.

 

Regards,

Xiaoxin Sheng

DieLem's avatar
DieLem
Icon for Helper II rankHelper II
8 years ago

Hi Anonymous,

 

I want to do what you say but I do not exactly understand. If you look in the third tab "YTD School Revenue" the difference is still 33M. It should be smaller values as in the graph above it.

 

How do I get the bottom graph to calculate "YTD Difference between 'School Stream Revenue' and 'School Stream Budget'? Currently it looks like it is calculating "YTD Difference between 'Total budget' and 'School Stream Revenue".

 

Thanks!