Forum Discussion
Graph problem with measure.
Hi and thanks for reading this.
I have a line and cluster column chart and i dont want the columns to be shown for "Bridge Who" when all values are show (se picture A).
I want it to look like picture B
When i click one one at "Bridge Who" i want it to look like Picture C ( that is working)
So basicly i dont want the values to be shown for "Bridge Who" when we show total , only when one is choosen
I hope i have manage to expalin myself.
The file i work with can be found:
https://drive.google.com/open?id=1xWcUAmV97cMla-BaP6ovRpTJgGi4KWn_
/Thanks
Picures A (How it looks now)
Picure B (This is how i want to look when all is shown)
Picture C
Not sure I got is completely but isfiltered or isinscope should help
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Measure = if (isfiltered(table[Bridge Who]), [count of Bridge Who],blank())
3 Replies
Wresen so I believe the way to fix your issue is to use HASONEVALUE as a check on Bridge Who and then if that is FALSE return BLANK in whatever you are using for your columns. If you are not using a measure, just create one with that check and if it is TRUE, do whatever aggregation you are using on the column used for the value in your columns (in your visual).
Not sure I got is completely but isfiltered or isinscope should help
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Measure = if (isfiltered(table[Bridge Who]), [count of Bridge Who],blank())
Thanks so much both.
I tried out amitchandak's measure and it worked perfectly 🙂
I will also read up on "HASONEVALUE" so i know about that also
Thank you both , amitchandak and Greg_Deckler.
