Forum Discussion
Data bar highest value
Hello @Jianbo,
I am using the table and matrix table visuals.
Is it possible? I have a "Stock level" column, and a "Reorder level" column. I would like the stock level column use data bars, and the highest value is taken from the Reorder level column.
Thanks for the reply.
Hi Anonymous ,
To my knowledge, your requirement could not be realized currently. An idea similar with what you expect has been submitted here, please vote it up and you can add comments. Hopes Power Bi will implement this in nearby future.
Besides, here is a workaround:
First add the Reorder level and rename it:
Conditional format it to data bar:
Output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sorry v-jianboli-msft I'm a bit slow, can you please clarify that again, I got confused on what to do with the Reorder level column
Hi Anonymous ,
Please try:
1. Add the Reorder level column into the Table Visual
2. Choose the aggregation you need:
3. Use the [Space] bar(Make its name display blank) to rename it:
Output:
4. Conditional format it to data bar:
5. Now you will have a column of data bar, you can move it to the place you need:
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks v-jianboli-msft for looking into this, this would have worked if there is only one "Reorder level" column, but I wanted to display the reorder level column as numbers as well, if I put two of the same column, Power BI will not allow me to rename one as space. Any more ideas?