Forum Discussion

S184019's avatar
S184019
Icon for Advocate III rankAdvocate 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
S184019's avatar
S184019
Icon for Advocate III rankAdvocate 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
Icon for Community Support rankCommunity Support
8 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