topic Re: Set custom shape color in Developer

Set custom shape color

Anonymous — Mon, 21 Jun 2021 09:15:07 GMT

Hi everyone,

I have two tables in my model, one table (Table1) I have all data what I need and another table (Table2) I created for select all measures in one sheet:

For example:

Vendas Reais = VAR Logic Test = COUNTROWS(DISTINCT(FILTER(ALLSELECTED('KPI´s'[KPI]),'KPI´s'[KPI] = " Vendas Reais"))) = 1 RETURN IF(LogicTest, [Real_Sale],blank())

The measure [Real_sale] is calculated in Table1.

I additional my report a shape (Oval) but we want this color shape change according to the selection of my measures. It´s a possible?

Thank you.

Re: Set custom shape color

V-lianl-msft — Wed, 23 Jun 2021 02:52:55 GMT

It should be explained that the fill color of Oval cannot be changed dynamically.

There is a workaround for your reference:

Set the fill color to white and set it to transparent.

Then in the background color, we add the measure and change the color dynamically.

Re: Set custom shape color

Anonymous — Wed, 23 Jun 2021 11:34:53 GMT

Hi @V-lianl-msft , thank you.

Your suggestion helped me a lot, but I have one more question.

If for example we select two measures in filter, I have to have two sharpes right? It´s possible build a workaorund for these case?

Thank you.

Re: Set custom shape color

V-lianl-msft — Thu, 24 Jun 2021 01:15:46 GMT

This is the way to solve the problem by creating a measure and using it as the conditional formatting of the color.

I'm not sure about your scenario and the expected results. Could you share a sample pbix and shown your expected results with pictures?