Hello,
I tried googling this but to no avail.
Anyhow, I'm constructing a dashboard with a donut chart with data from two tables:
1. Product (9 different products)
2. KPI values (6 different KPIs)
Each table has a slicer with which you can select for instance:
- one of the KPIs and see what share each of the Products have
- one of the KPIs and two of the Products if I want to compare two similar Products
After selecting either of the KPIs I've given each Product its own color using Format data point.
However when I select one KPI and two Products the pie chart reverts to using other colors for the two Products.
I would think it kind of nice if the Products had the same colors that I've set by using Format data point.
I'm thinking it may have to do with how the data for the chart is organized? Or what am I missing?
Also, it doesn't really matter if it's a pie chart or a donut chart.
Best,
Fredrik
I tried googling this but to no avail.
Anyhow, I'm constructing a dashboard with a donut chart with data from two tables:
1. Product (9 different products)
2. KPI values (6 different KPIs)
Each table has a slicer with which you can select for instance:
- one of the KPIs and see what share each of the Products have
- one of the KPIs and two of the Products if I want to compare two similar Products
After selecting either of the KPIs I've given each Product its own color using Format data point.
However when I select one KPI and two Products the pie chart reverts to using other colors for the two Products.
I would think it kind of nice if the Products had the same colors that I've set by using Format data point.
I'm thinking it may have to do with how the data for the chart is organized? Or what am I missing?
Also, it doesn't really matter if it's a pie chart or a donut chart.
Best,
Fredrik