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?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

hello dk_dk , good idea, I did it but it leaves a gap between two columns for the actual sales: 

 

 

Any workaround for this?

 

Thanks, 

Ekta

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 🙂