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

Hi Anonymous ,

The solution I can think of would be that you separate the Sales actuals (sales that already happened, for months closed) and the Forecasted sales (for months not yet closed) into two different measures. I understand that right now [Sales YTD Value] contains it all. I would instead create two measures (using CALCULATE), one where you show Sales YTD Value only for months that are closed, and 0 for the other months, and then another measure when you show 0 for months that are close, and Sales YTD Value (the forecast) for months not yet closed. Then you can visualise 3 measures together and format them separately.