Forum Discussion

Bram12's avatar
Bram12
Regular Visitor
3 years ago

stacked column chart

Hi,

 

I want to make a stacked column chart over the years 2021, 2022, 2023. Herefore I had to calculated the the amounts through measures between different datasets. In the end all the datasets use dates which are similar but I have to use them on the x-asis to get the right amount. I want to merge the dates so that only the ones with 2021, 2022 and 2023 stay in the chart (so not the combination 2021, 2021, 2022 or others). Can someone maybe help me to solve this problem? As seen in the picture below, all the possible options are now shown in the columns. 

The filters have to stay in the same way. Does someone have the solution? 

 

Thank you in advance

2 Replies

  • Hello Bram12 ,

     

    in the format of the visual under the x-axis , set the concatenate labels to ON as in the screenshot.

     

     

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    Follow me on Linkedin

    • Bram12's avatar
      Bram12
      Regular Visitor

      Unfortunately this is not the solution yet. I already had the label on.