Forum Discussion

NikhilChenna's avatar
NikhilChenna
Skilled Sharer
3 years ago

Hi sanju24566 ,

 

I think we already got the solution. you just have to visual level fiter to this visual.

 

After this you can create calculated column to for your condition of value 1.5 average value.
calculated column = IF('table1'[AvgValue]>=1.5,1,0)
 
Add this calculated column as visual level filter. You should get the desired output.
 
Regards,
Nikhil Chenna
 
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
sanju24566's avatar
sanju24566
Regular Visitor
3 years ago

i have already used it in the visual above with Year in the axis. But the Count is coming 19 which is Total Count of Site Code

  • NikhilChenna's avatar
    NikhilChenna
    Skilled Sharer
    3 years ago

    Hi sanju24566 ,

     

    Can you provide me this below excel file with few entires. I will try again and let you know in few mintues. 

     

    Regards,

    Nikhil Chenna