Forum Discussion

sravansadu's avatar
sravansadu
Regular Visitor
9 years ago

Color code a legend based on a measure in scatter plot

   Hi,   I am creating a scatter chart for different hierarchy level. For each individual person in the lower level of the hierarchy, I created a column that categorizes him under particular range...
Need Help
v-micsh-msft's avatar
v-micsh-msft
Microsoft Employee
9 years ago

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:

Power BI desktop

Regards

 

  • sravansadu's avatar
    sravansadu
    Regular Visitor
    9 years ago

    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!