pareto chart problem

[Anonymous]

Hi Have the following measure to get a pareto chart, however the chart shows suppliers that doesnt have any value e.g. no case number related - does anyone have an idea on how i can avoid this?

1 CountCases = DISTINCTCOUNT([Case Number])

2 RankSupplier= RANKX(ALL(CR[Supplier]);[CountCases])

3 AmountAllSupplier= CALCULATE([CountCases];ALL(CR [Supplier]))

4 ParetoValueSupplier= SUMX(TOPN([ColorRank Supplier];ALL(CR[Supplier]);[CountCases]);[CountCases])

5 Pareto % Supplier = DIVIDE([ParetoValueSupplier];[ AmountAllSupplier])

[v-shex-msft]

HI @Anonymous,

If you can please share some sample data for analysis. It is hard to clarify your issue without any data.

Regards,

Xiaoxin Sheng

[Anonymous]

hi While i was trying to create a sample file, i found out what the problem was - because i coudlnt recreate the problem in the sample file. The date was the problem - i am using the date from a calendar table when i remove that the problem is gone but I need a date filtering option and when i use the date from the pareto table it will not format it as date, when if i have changed the format from PBI QUery

Should you by any chance happen to know why this happens?

[v-shex-msft · Accepted solution]

Hi @Anonymous,

I think it may related to power bi time intelligence feature, perhaps you can take a look at below article to know more about it:

Time Intelligence in Power BI Desktop

Regards,

Xiaoxin Sheng