cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
niketmistry7 Frequent Visitor
Frequent Visitor

Re: TOPN in graphs/Dynamic

Hey @Ashish_Mathur,

 

Can you please help me with the rank formula syntax? Because the values on the charts are added based on unique supplier/parts/dealer number and day groups. 

 

formula is like= for each supplier number, count (>14)/ Grand total (>14) + count (8-14)/ Grand total (8-14)  + count (2-7)/ Grand total (2-7) + count (0-1)/ Grand total (0-1)  

 

Thanks

Super User
Super User

Re: TOPN in graphs/Dynamic

Hi,

 

Share the link from where i can download your file.  In a simple Table, also show the expected result.

niketmistry7 Frequent Visitor
Frequent Visitor

Re: TOPN in graphs/Dynamic

Hey Ashish,

 

Sorry for the delay. I am attaching the link herehttps://drive.google.com/open?id=0B3RVPzvmX8RMa3FiTXVodXhyMDVyMVExNGczZG83MFpfcmUw. What I need is, instead of the stacked bar charts showing all the parts/supplier/dealer numbers, I just want top 10 of them to show based on the Percentage Grand total Count of Customer Order ID. This same parameter: %GT Count of System_CustomerReferenceOrderID is used as a value in all the stacked charts. 

Super User
Super User

Re: TOPN in graphs/Dynamic

Hi,

 

I cannot download the file from there.  I get an access denied message.

niketmistry7 Frequent Visitor
Frequent Visitor

Re: TOPN in graphs/Dynamic

Parihar1980 Regular Visitor
Regular Visitor

Re: TOPN in graphs/Dynamic

Hello Sir, 

I am using year based slicer and expected result would be Last 5 year sales based on Year slicer selected value. Since I am using tabular model so i have limitation ; i can't use some date like SELECTEDVALUE, etc in my solution. 

 

Please help me 

 

https://community.powerbi.com/t5/Desktop/Sales-over-the-year-with-Dynamic-year-value/m-p/481273#M224...