Forum Discussion
Data bar highest value
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?
Hi Anonymous ,
The reason you can't rename it is because you are actually adding the same measure generated by the 'reorder level' field for the second time. Thus, you cannot add and rename it again.
You can create a new measrue to display the number of 'reorder level':
Reorder Level' = SUM('Table'[Reorder level])Note: The new measure and column "reorder level" cannot have the same name
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.