Forum Discussion
Sync sliders problem
Hi to everyone.
I got the issue, my pbix file has 30 similar pages, each with the following pattern:
a) table on 2 dates (year-end and latest date)
b) monthly chart (12 months or more)
Every month I'm rolling input data by adding another month, so I have to do a very boring thing - change the date in table (a) on each (!!!) page.
So, I supposed that dates slicer in connection with "sync slider" will help me.
I created such slicer on another page, connected with all pages, but did not take into account that such slicer has an effect on table (b) which supposed to have all dates.
So, question. How can I disable that slicer from table (b) and keep it active on table (a) at the same time?
Thanks in advance!
P.S. it worth to notice, a and b has one source
Anonymous You can try a couple options:
A) Edit interactions so that slicer does not impact the table b. https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
B) Create a measure that ignores the slicer (using ALL(Date) for example) and put that in table b.
3 Replies
Anonymous You can try a couple options:
A) Edit interactions so that slicer does not impact the table b. https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
B) Create a measure that ignores the slicer (using ALL(Date) for example) and put that in table b.
Anonymous Yes, definitely a bit of setup required, but once it's setup should be low maintenance moving forward.