Pie chart with measure

[msam86]

Hi friends,

In another topic I had help creating a measure. Now I'm trying to create a pie chart to see the consolidated information. I want to know how many times Attention or compliance appears when I select the YEAR. Is this possible? 

Ex.1:

ex.2:

Regards!

[v-yangliu-msft · Accepted solution]

Thanks for the reply from @Kaviraj11 , please allow me to provide another insight: 

Hi  @msam86 ,

I couldn't open your PBIX on my end, so I created the data:

Here are the steps you can follow：

1. Enter data – create a table.

2. Create measure.

Measure=
COUNTX(
    FILTER(ALL('Dados'),[Status]=MAX('Table'[Status])),[Status])

3. Result:

Note: You need to change [Status], delete the formula “MAX(Dados[MesclaANO]) -- Default to the original status if no condition matches”, or replace it with the same formula as before. data type (this formula data type is text)/blank () instead of

According to Power BI design, there can only be one data format in a column of data, and “Compliance” is a text type, MAX(Dados[MesclaANO]) is a date type.

Status =
VAR SelectedYear = SELECTEDVALUE('DataParameter'[DataParameter])
RETURN
SWITCH(
    TRUE(),
    YEAR(MAX(Dados[MesclaANO])) < SelectedYear, "Down",
    YEAR(MAX(Dados[MesclaANO])) = SelectedYear, "Attention",
    YEAR(MAX(Dados[MesclaANO])) > SelectedYear, "Compliance"
)

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[msam86]

Thank you my friend. I understood what you did and applied it to my table.

Regards

[msam86]

Hi guys,

I created a pbix file to help understand what I need.

I need to count how many times the measurement words appear and are shown in a pie chart.

Regards

Download pbix:

https://acesse.dev/c4VJ7

[Kaviraj11]

Yes, It's possible. Drop in the Pie Chart, Put the measure created into 'Values' section & Column that contains Attention or complianc into the legend section. You will have the ability to select the label contents under Details Labels section too. 

[msam86]

Hi @Kaviraj11 , but there is one point that I forgot to mention: I created this measurement using a parameter:

Status =

VAR SelectedYear = SELECTEDVALUE('DataParameter'[DataParameter])

RETURN

SWITCH(

    TRUE(),

    YEAR(MAX(Dados[MesclaANO])) < SelectedYear, "Down",

    YEAR(MAX(Dados[MesclaANO])) = SelectedYear, "Attention",

    YEAR(MAX(Dados[MesclaANO])) > SelectedYear, "Compliance",

    MAX(Dados[MesclaANO])  -- Default to the original status if no condition matches

)

I need this condition year after year to visualize the pie chart.