Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Data bars in data table for % value

Hello,

 

Can anyone please let me know how I can use % measure in data table to show as data bars (conditional formatting option). When I do for a normal value the bars comes up but when I convert it to % and it doesn't show up. Is there a way I can do it?

 

 

Thanks,

Karthik

Need Help
Show and Tell

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , You have to use a % of total column (or right click on measure in value and use % of total)

     

    Divide(sum(Table[Earned Hours]) , calculate(sum(Table[Earned Hours]), allselected()))

     

    Databar do not provide option to select a different column