Forum Discussion
Helper IChange visual/formatting based on slicer selection
Hello!
I am trying to understand if it is possible to change the graph type or at least the formatting based on user selection. For example, in this visual, the 'line' trend makes sense only when 'time' (mon/qtr/year) is selected.
1. When vendor or subchannel are selected, it should display stacked column chart instead of a line and column chart. Is this possible?
2. If not, is there a way we can make the line width = 0 when vendor or subchannel are selected so that we don't see the line?
Kindly let me know if you need more information on this for understanding. Thanks so much in advance for your time.
Hu freebird28
Both of your requests are possible only using bookmarks, you can add buttons that users can press and change the visual types. This functionality is not available based on data/hierarchy levels.
About the issue of line there is an idea you can vote for :https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=e10a9518-796b-4bc9-b8bc-4c1174a3f8c5
and suggest others.
Note that the graph with two axes is inefficient for any type of variation or design, as well as for any type of interaction when it comes to data visualization.
Please refer to the linked article:
https://blog.datawrapper.de/dualaxis/If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi freebird28
Glad to help.
This video is a good tutorial to switches of visuals using bookmarks:
https://www.youtube.com/watch?v=cFZtUzABOa8I believe it can assist.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
- Ritaf1983
Super User
Hu freebird28
Both of your requests are possible only using bookmarks, you can add buttons that users can press and change the visual types. This functionality is not available based on data/hierarchy levels.
About the issue of line there is an idea you can vote for :https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=e10a9518-796b-4bc9-b8bc-4c1174a3f8c5
and suggest others.
Note that the graph with two axes is inefficient for any type of variation or design, as well as for any type of interaction when it comes to data visualization.
Please refer to the linked article:
https://blog.datawrapper.de/dualaxis/If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
freebird28Hi Ritaf1983
Thank you so much for your response. Yeah, bookmarks is the option that came to my mind first. Since this chiclet slicer is being used by other visuals on that page, I am hesitant to redo everything using buttons. I have voted for this feature and will take a look at the link you have provided for better understanding. Thanks once again.
- Ritaf1983
Hi freebird28
Glad to help.
This video is a good tutorial to switches of visuals using bookmarks:
https://www.youtube.com/watch?v=cFZtUzABOa8I believe it can assist.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly