Forum Discussion
Color code a legend based on a measure in scatter plot
Hi sravansadu,
I assume this should be caused by the hierarchy. If you use measure, data would change as the filter (hierarchy) changes. And the data range might go wrong.
Would it be available for you to share the data model (or a data sample) here? I will make some tests based on your data model.
In addition, I saw your Power BI desktop is still in the old version, please download the most updated one:
Regards
Yes, you are right that the filter works well with the measure. However I am not sure about the range how to create on basis of measure. I created range using column but when the filter is applied(even when I use filter to select particular dates) then the color legend doesn't work well.
Unfortunately, I can't share the data model or sample. I will try to replicate similar data set for you if possible by tomorrow.
I will download the latest version but I don't think this issue is because of the version. Is there anyway that I can use some function in the legend using a column. For example, I used sum function in the column that I gave under x-axis and y-axis and also I gave average function for size. These all are working fine but I couldn't find a way to create function in legend for the column that I am using under it. Please let me know if there is anyway to do that. Thank you!