Forum Discussion
pareto chart problem
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])
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
3 Replies
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?
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