Forum Discussion

JohannTTG's avatar
JohannTTG
Helper I
6 years ago
Solved

Histogram - space for empty bars

Hi, I have a histogram. The x-axis shows the years, the y-axis some values. Now the user can select the years with checkboxes (multiple selection).   If the user selects consecutive years (e.g. 2...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, JohannTTG 

     

    Based on your description, I created data to reproduce your scenario.

    Table:

     

    You may create the 'Year' column as below. Its data type is text.

    Year = FORMAT('Table'[Date],"yyyy")

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • JohannTTG's avatar
    JohannTTG
    6 years ago

    Thank you - your suggestion showed me the way. I convert the x-axis-number to text and this does the job!

JohannTTG's avatar
JohannTTG
Helper I
6 years ago

 

As screenshot for clarification: I don't want to see 2016 and 2018

amitchandak's avatar
amitchandak
Super User
6 years ago

JohannTTG ,  Does you measure/formula has +0. if so remove and check.

Otherwise.

Can you share sample data.

  • JohannTTG's avatar
    JohannTTG
    Helper I
    6 years ago

    Thanks for your quick reaction.

     

    There are values > 0 for every (!) year. All the user wants is to remove the gaps for non-selected years.

     

    • JohannTTG's avatar
      JohannTTG
      Helper I
      6 years ago

      If I look at the data as a table then I do not see data for the not-selected year.

       

      • v-alq-msft's avatar
        v-alq-msft
        Community Support
        6 years ago

        Hi, JohannTTG 

         

        Based on your description, I created data to reproduce your scenario.

        Table:

         

        You may create the 'Year' column as below. Its data type is text.

        Year = FORMAT('Table'[Date],"yyyy")

         

        Result:

         

        Best Regards

        Allan

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.