Forum Discussion
Data Bar in Columns
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%