Forum Discussion

Rakesh_508's avatar
Rakesh_508
Icon for Helper I rankHelper I
2 years ago
Solved

barchart - measures

Hello,   I am using two measures in a bar chart for displaying values of goals orders count and completed count and in the x axis, stations values are displaying like A B C D E..... The values in ...
Need Help
  • dk_dk's avatar
    dk_dk
    2 years ago

    Hi Rakesh_508 

    You could try to create a third measure that looks something like this:

    Measure 3 = IF([Measure 1]=0 && [Measure 2]=0,"filter","keep")

     

    You can then add this measure as a visual level filter on your chart, and configure Show items when the value is "keep".

    Let me know if this works for you.

    Best regards,
    Daniel

dk_dk's avatar
dk_dk
Icon for Super User rankSuper User
2 years ago

Hi Rakesh_508 

You could try to create a third measure that looks something like this:

Measure 3 = IF([Measure 1]=0 && [Measure 2]=0,"filter","keep")

 

You can then add this measure as a visual level filter on your chart, and configure Show items when the value is "keep".

Let me know if this works for you.

Best regards,
Daniel

Rakesh_508's avatar
Rakesh_508
Icon for Helper I rankHelper I
2 years ago

dk_dk  I did the same but instead of =0 , Im trying to use<>0.. thats why its not working for me....
Thanks, your solution worked for me....