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 ...
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% |