Forum Discussion

S184019's avatar
S184019
Advocate III
8 years ago

Calculated field data bars

Is it possible or perhpas already in the works to be able to add data bars to DAX calculated fields?  Once a field is calculated it seems that the data bar option is no longer available.    Thanks,...
Dashboards
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi S184019,

 

Based on my test in Power BI desktop August version, as long as the calculated column putted in the table visual has been set with one aggregation (eg: SUM), the Data Bars is available in conditional Formatting options. 

 

In your scenario, please ensure the calculated field you mentioned has be set with one aggregation. Please run desktop August version if possible. 

 

Best Regards,
Qiuyun Yu 

S184019's avatar
S184019
Advocate III
8 years ago

v-qiuyu-msft

 

Thank you for this quick reply!

 

Alas, the code shows 2 separate aggreagation types:

  1. Summing the first 3 cols.
  2. % Growth / 100 in last col.

Perhaps this is something which may be added to DAX or PBI in the future?  Dax Code could be:

 

FORMATBAR('Table'[Column],MIN,MAX)

 

Is there another work around? 

 

Thanks again for the help!

 

 

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    7 years ago
    S184019 wrote:

    v-qiuyu-msft

     

    Thank you for this quick reply!

     

    Alas, the code shows 2 separate aggreagation types:

    1. Summing the first 3 cols.
    2. % Growth / 100 in last col.

    Perhaps this is something which may be added to DAX or PBI in the future?  Dax Code could be:

     

    FORMATBAR('Table'[Column],MIN,MAX)

     

    Is there another work around? 

     

    Thanks again for the help!

     

     

    Hi S184019,

     

    Not sure what you mean about above highlighted section? Would you please share some screenshots to clarify it? 

     

    Best Regards,
    Qiuyun Yu