Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi PBI users, I have a dashbord with bar chart, so axis x (dimension values) and axis y with measure, and table visual with values.. etc In the filters pane I have the filter with the same dimension than I have in bar chart; so when I filtering the bar chart, the table filters too with the values OK, It's fine, but the filters pane don't update the right values :(, vice versa Works (pane filter to bar char).
Is there a way to update the right values in the filters pane when the filter is applied from any visual in the report?
Thanks.
Solved! Go to Solution.
Hi, @Peter_23
Thanks for Joe_Barry positive reply. You can use a single slicer to achieve your need, then vision 2 disconnects the interaction with Slicer. In your description, you can see that Vision 2 displays the full Year-Month,so the Year-Month in the Pane Filter of Vision 1 is not affected. This is by design.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi, @Peter_23
Thanks for @Joe_Barry positive reply. You can use screenshots to describe the problem you're currently experiencing to make it easier to understand, and then share the pbix file without sensitive data for testing purposes. This will help you to solve the problem faster, feel free to help you about this problem.
Best Regards,
Yang
Community Support Team
Hi @Anonymous @Joe_Barry I have a example, the in this first screenshot the filter is from filter pane and works OK to visual A and B.
The next screen the filter is from visual A so visual B and chart are filtered OK (March), but the ppane filter (Date) it show all values e.g. others months . 🙄
I would like the filter pane only show the value affected by cross-filter in visua A. 😉
Because if I apply a filter from filtre pane the visual B and chart are blank. 😞
I share a example.
Thanks in advance.
Hi, @Peter_23
Thanks for Joe_Barry positive reply. You can use a single slicer to achieve your need, then vision 2 disconnects the interaction with Slicer. In your description, you can see that Vision 2 displays the full Year-Month,so the Year-Month in the Pane Filter of Vision 1 is not affected. This is by design.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi @Joe_Barry I mean the Pane Filter (first section), I haven't slicers, I only apply the visual filter by click it, then the Pane filter dimension should be show me the right values, but it doesn't happen. 😞
Hi @Peter_23
Do you mean this section? Or do you have slicers?
If you have slicers, Highlight the slicer, then You can add your measure to the Filters section as show above and set the measure to "is not blank" repeat for each slicer where the measure is sliced by
Hope this helps
Joe
Proud to be a Super User! | |
Date tables help! Learn more