Forum Discussion

chaima1's avatar
chaima1
Regular Visitor
9 years ago
Solved

Need help without dax

Hello,    I start using bi power last 3 days, and using it I have to present my top 2 products ( the names of my column in the example)  in each period. My top product is the one which have the top...
Need Help
  • chaima1's avatar
    chaima1
    9 years ago

    Hello, 

     

    Thank you all of you, I am new with BI power so I make stupid mistakes and I didn't pay attention that my data are text, and I am using %, so for that reason I can't get any graph, now that works very good. 

     

    Thannnnk you

chaima1's avatar
chaima1
Regular Visitor
9 years ago

Thank u sir, I will try your method. 

 

 

 

chaima1's avatar
chaima1
Regular Visitor
9 years ago

The problem that I have now is when I import my table the name of my colomns will be the date, and I want to make a filter on the dates, so that will not work-just like my table will be overturned, I don't know what should I do? 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi chaima1,

     

    You can try to use below formula to get the top 2 produce of each period.

     

    unpivot table.

     

    Add rank to filter table.

     

    Table = FILTER(ADDCOLUMNS(Sheet1,"Rank",RANKX(FILTER(ALL(Sheet1),[periode]=EARLIER(Sheet1[periode])),[Value])),[Rank]<3)

     

     

     

    Regardsm

    Xiaoxin Sheng

    • chaima1's avatar
      chaima1
      Regular Visitor
      9 years ago

      Thank you so much both of you, 

       

      That works very good now, I want just to add a filter on the dates. I order that the user can choose more that one date, and at the same time that will looks good. 

       

      Thanks again

      • chaima1's avatar
        chaima1
        Regular Visitor
        9 years ago

        I wish that you can help me to visualize the evolution of % of my top products by a graphic, 

         

        Thank you