Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to 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
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
Thank you my friend. I understood what you did and applied it to my table.
Regards
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:
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.
Proud to be a Super User! | |
Hi @Kaviraj11 , but there is one point that I forgot to mention: I created this measurement using a parameter:
I need this condition year after year to visualize the pie chart.
User | Count |
---|---|
123 | |
70 | |
67 | |
58 | |
53 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |