Forum Discussion
PBI trick: Making an object disappear after filter selection
- 6 years ago
I have a possible solution...when you want people to still interact with the scrollbar, you can do this easy by making the card not cover the whole visual, so they can still click and scroll the bar.
See the pictures as example, i use a shape that isnt filled to make sure the visual cannot be interacted with. It doesnt cover the header/title and doesnt cover the scrollbar. So users can still scroll through the visual.
I guess you could use a drillthrough if the user right clicks on the header or scrollbar area. Maybe inform the user of this "functionality" in the text.
Visual when nothin is selected.Visual when something (a weeknr in this case) is selected.
Good luck, hope this helps.
One way is you create color measure like these and use in advance control color formatting. You should see that under conditional formatting or after you hover the mouse over the color, you should three dots. You have the option there.
One way is to make both background and font color white.
Color Brand = if(FIRSTNONBLANK('Item'[Brand],BLANK())="Brand 11","red","green")
Color scatter = if(SUM(Sales[Net Sales])>2500 && SUM(Sales[Margin])>400,"green","red")
Other is bookmarks
https://www.youtube.com/watch?v=_Afcj8mT5_Q
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin