Forum Discussion

faerewatson's avatar
faerewatson
Advocate I
8 years ago

bar chart visualization - unable to select data if values are significantly smaller than others

I want my end users to be able to select values from this bar chart (screen shot below) to filter the values in a table below... but because the first bar is so high (2,328), the smaller values (9, 5...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi faerewatson.

 

I't like to suggest you add legend field, then choose specify legend to instead manually select smallest bars.

 

BTW, you can also use axis column to create a slicer to apply filter effect.

 

Regards,

Xiaoxin Sheng

faerewatson's avatar
faerewatson
Advocate I
8 years ago

Thanks Anonymous - can you clarify a little further?

 

1) I don't love the legend field as (in my case at least) there are 30+ categories which clutters up the top of my visualization (and then travels too far outside of my color palette as each category is given another color - and updating each data color to the same will a lot of time). I also have shrunk the legend font to 8 and I still can't see all of my values. :(

 

2) What do you mean by "use an axis column to create a slicer to apply filter effect"?

 

Thanks!

  • faerewatson's avatar
    faerewatson
    Advocate I
    8 years ago

    For now, I have updated my bar chart to only show the top 10 concepts which reduces the discrepancies between the largest value and the smallest value. If anyone finds a better solution, I would love to hear it!

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      HI faerewatson,

       

      Current it seems like not contains highlight slicers. Maybe you can create other visual as highlight filter.

       

      For e.g.

       

       

      Regards,

      Xiaoxin Sheng