Forum Discussion
Data Bar in Columns
Hi, I have a column with % values. I need to show this column in a table visual, but not doing any aggregation.
I want to show a databar for each % value, problem is Power BI only shows the databar conditional formating if I summarize the values (sum, count, etc) but I need to see the values exactly as they come from the database. I need something like the image
Can anyone help?
3 Replies
Hi Ramon_Mac ,
Create a measure as below:
Measure = SELECTEDVALUE('Task'[PercentValue])Put it in the table and then turn on the data bars on this measures. It gives you what you need without any aggregations.
If it helped, mark it as an accepted solution.
Regards,
Loran
I already tried it and doesn't work, I don't know the reason but it don't show all the values, only 30% and 0%.
Aha Okay.
The reason is that you have same records for your tasks. for example you have 2 records for Task1
Then SELECTEDVALUE() does not work in this case becasue there are 2 records for Task1. So the measure with SELECTEDVALUE would be blank and it does not show you the related number for that.
But If you put another column of your table that could result in showing you both of the Task1 records, the above solution would work.
Assume you have the below table. If you put only TaskName and the created measure, then it does not show you the task1. But if you add Group column, it would show you the task1 record.
TaskName Group PercentValue Task1 A 10% Task1 B 20% Task2 C 15%
