Forum Discussion
Why does column show 100% when filter applied
Hello
I hope someone can provide me with some insight into an issue i am having.
I have a reprot with basically 2 histograms. One show $ across all states and the other shows % to total budget spent per a category. For some reason when you click on the state in the first histogram the second one changes all the % to 100%:
It seems to be automatic as i cannot locate where the function is coming from.
Any insight is appreciated.
The Second Histogram with % is getting highlighted and if you dont want that you need to Restrict interaction.
Selection $ Histogram, on top select Format Tab and Select Edit Interaction (Extreme Top Left) and activate it.
you can see few Icons on top of % Histogram (make sure your $ chart is still selected), and select the None button
which will reduce the interaction from $ chart to % chart so you donot see any such change explained above.
Follow this picture and hope this will be an answer for you .
If you find this as solution please mark the same and Share your Kudos!
Regards
Vijay Perepa
5 Replies
The Second Histogram with % is getting highlighted and if you dont want that you need to Restrict interaction.
Selection $ Histogram, on top select Format Tab and Select Edit Interaction (Extreme Top Left) and activate it.
you can see few Icons on top of % Histogram (make sure your $ chart is still selected), and select the None button
which will reduce the interaction from $ chart to % chart so you donot see any such change explained above.
Follow this picture and hope this will be an answer for you .
If you find this as solution please mark the same and Share your Kudos!
Regards
Vijay Perepa
