Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Conditional formating for bar chart in histogram

hello, I created a histogram which displays the sales for this year and last year for each month, the dark blue color is 2023 and the light blue color is 2022. For the month of November and Dec...
Need Help
  • dk_dk's avatar
    dk_dk
    2 years ago

    ah yeah of course... 

    I found this other thread that describes the same issue but it seems that the intended behaviour is not possible with the clustered column chart.

    Some other threads say to set the value to null, instead of 0 (in the two measures you created) that may be worth a try?

dk_dk's avatar
dk_dk
Super User
2 years ago

Could you apply a Visual level filer with the condition that [Measure] >0 for both measures?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

dk_dk It did not work, the moment I am filtering on both, the page goes blank, if i am filtering > 0 only for actual sales, I don't see the forects part and vice versa

  • dk_dk's avatar
    dk_dk
    Super User
    2 years ago

    ah yeah of course... 

    I found this other thread that describes the same issue but it seems that the intended behaviour is not possible with the clustered column chart.

    Some other threads say to set the value to null, instead of 0 (in the two measures you created) that may be worth a try?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Tried it already, didn't work but thanks a ton for your help 🙂 90% of the chart is done so I will accept the solution 🙂

      • dk_dk's avatar
        dk_dk
        Super User
        2 years ago

        Thanks! If anything maybe browse around in the custom visuals to see if there is something else that allows more control.