Forum Discussion
Question about graphics attributes
The same thing, but with pictures this time! All of these options are identical regardless of the data source - that's the promise of Power BI, no matter where your data comes from you can treat it all the same in PBI. In this case, the promise is true. The following color options are identical for all sources. It does not matter if your data is coming in from Excel. Here's what Anonymous and I have been saying.
Saturation gives you a range between 2-3 colors based on the evaluation of a measure for the point plotted (depends on divergent or non-divergent)!
Note the measure value in the color saturation well for the map visualNote the definition of data colors in the formatting pane.
Your other option is to use the legend, which automatically assigns a unique color to every legend entry!
Note we've got a field in the legend well for the map visualization!See how we can change the colors for those legend entries manually in the formatting pane of the map visual!
The keen observer will note that we used the same formatting menu, 'Data colors', for each of these options. Legend and color saturation are mutually exclusive in a map.
Have fun with your info from the Excel file.
OK, thank you, I will try it.
But, as I said, I need to get all the info from Excel file, and, as I understand, I cannot change the color using Excel (or any other external option) - only saturation. Is it true?
The same thing, but with pictures this time! All of these options are identical regardless of the data source - that's the promise of Power BI, no matter where your data comes from you can treat it all the same in PBI. In this case, the promise is true. The following color options are identical for all sources. It does not matter if your data is coming in from Excel. Here's what Anonymous and I have been saying.
Saturation gives you a range between 2-3 colors based on the evaluation of a measure for the point plotted (depends on divergent or non-divergent)!
Note the measure value in the color saturation well for the map visualNote the definition of data colors in the formatting pane.
Your other option is to use the legend, which automatically assigns a unique color to every legend entry!
Note we've got a field in the legend well for the map visualization!See how we can change the colors for those legend entries manually in the formatting pane of the map visual!
The keen observer will note that we used the same formatting menu, 'Data colors', for each of these options. Legend and color saturation are mutually exclusive in a map.
Have fun with your info from the Excel file.
Thanks a lot for your explanations.
I am a new customer of Power BI, so not all is clear for me, but I will try to do what you are recommended.
Mark.