Forum Discussion
Solved
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 p...
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())
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.
