Forum Discussion
[Help] Two filters refresh
Hello everybody, good afternoon
The reason why Im writing here, and asking for you help, is because I have a question about 2 filters Im using in an inform on PwBI Desktop. Is not a content thing but a form thing.
I have 2 filters, the first are Company names and the second are Bonds emitted by these companies. For example, this picture show the first filter selected at JP Morgan and the second one shows all the bonds emitted by JP Morgan:
https://i.ibb.co/9nTTZnP/Filtros1.jpg
Thing is, when I wanna check the bonds from another company, such as Ford, I select the company in the first filter but the second one dosnt change automatically, and it remains showing the JPMorgan's bond we were checking before:
https://i.ibb.co/V9SqN6h/Filtros2.jpg
Seems the only way of changing that, is manually opening the second filter and choosing any of the 3 Ford's bond:
https://i.ibb.co/GdG2Bs8/Filtros3.jpg
So when i choose one of the Ford's bond, the JPMorgan's bond disappears and its all good:
https://i.ibb.co/41JMpLw/Filtros4.jpg
The thing is, the people who is going to use and read this report isnt much computer-friendly, even the less Power BI friendly, so Im asking if theres a way to avoid the manually setting, and that the second filter refresh inmediatly showing only the bonds that correspond, and not the one that was shown before the first filter changed.
As always, any help is appreciated it.
Thanks in advance.
Best regards,
Cristóbal
Hi Anonymous ,
If your line chart is similar with the following sample,
Then we can create a Tooltips page to meet your requirement, you can change the visual or theme of this tooltips page, then fiter the column2 is not A3.
Best regards,
3 Replies
Hi Anonymous ,
We can set two slicers can filter each other in "Edit Interaction" and disable single selection for sub-category as a workaround. So we can only select another category after we cancel select sub-category.
Or we can use bookmarks as filter of categories (Page 2).
Best regards,Hello v-lid-msft, it worked, thanks!
Before closing the topic, I have a final, and probably very easy to solve, question, about a lines graphic Im using in the report:
The label of each event shows 3 values, the closing and buying price for a commoditie, but it also shows the number of the month that you are consulting in the graphic (september = nummes = 09).
Since that value (nummes) is part of the graphic (axis), is there a way for not showing that information in the label, but only showing the 2 prices?
Thanks in advance!
Best regards,
Cristóbal
Hi Anonymous ,
If your line chart is similar with the following sample,
Then we can create a Tooltips page to meet your requirement, you can change the visual or theme of this tooltips page, then fiter the column2 is not A3.
Best regards,