Dear Sam,   Please find the attached PowerBI doc for your reference and let me know your valuable suggestions on this.   Regards, Sri ... View more

Dear Sam, Thanks a lot for your quick reply. Yes, I am trying the same way while data prep. Once again thank you so much. Regards, Sri ... View more

Dear Petri, Thanks a lot for your quick reply. Actually I also created using with "Frequency" as measure and in the Data Tip Values section I have included the original measure. Even I am getting pie slices for zero/missing values too. what ever you are saying it's 100% correct. But when I selected "Actual Values" section I am able to see for missing/zero departments it's showing as 1. where as it should be zero (0). Kindly suggest. Regards, Sri ... View more

Dear Curtis,   Yes, I am using SAS Viya for the reports creation. Here I am showing Top 3 customers in barchart. and in another bar chart I want to show top1 customer related Top 3 scores only , and 2nd bar chart I want to show top 2nd one related Top 3 scores only, and 3rd bar chart I want to show top 3rd one related Top 3 scores only.    Kindly suggest. Regards, Sri  ... View more

Sorry for inconvenience...attached new format (pdf) ... View more