Forum Discussion

DeeapkBI's avatar
DeeapkBI
Regular Visitor
3 years ago
Solved

Data bars

  Hi All, I was trying to apply Data Bar to my Sales, Profit or Quantity Column . When I select SALES column then I am getting the option DATA BAR however when I select the PROFIT OR QUANTITY c...
Need Help
Show and Tell
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi DeeapkBI 

     

    Please check if you have selected "Don't summarize" for Quantity and Profit columns. With "Don't summarize", they will not show "Data bars" option. Instead, select "Sum" aggregation type for them, then "Data bars" option will appear. 

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
3 years ago

Hi DeeapkBI 

 

Please check if you have selected "Don't summarize" for Quantity and Profit columns. With "Don't summarize", they will not show "Data bars" option. Instead, select "Sum" aggregation type for them, then "Data bars" option will appear. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!