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())
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).