Forum Discussion

ABideImen___28's avatar
ABideImen___28
Frequent Visitor
4 years ago

Slicer order

Good evening I've been looking for a solution to my problem for almost a month and I still haven't found a solution I hope you can help me. I built a datawarehouse following a star schema and this datawarehouse contains a fact table that calculates for each customer for each project for each sprint the load carried out. Knowing that several projects have sprints in common and ordered differently. My problem is that when I filter by project it shows me the corresponding sprints in the wrong order I tried with switch() but it doesn't work because several projects have sprints in common and in a different order I'm looking for a solution so that when I choose a project it shows me the sprints in the corresponding order

Tips and Tricks

4 Replies

  • ABideImen___28's avatar
    ABideImen___28
    Frequent Visitor
    4 years ago

    Hi mohammedadnant 

    Thank you for answering
I tried it but it doesn't work because the same value will have several ids.
    Here is what i tried :
    I create a column that concatenate the 3 ids with DAX :

      Then i sorted sprint column with this new column :

    it said that i can't sorted because 

    you cannot have several values ​​for the same value in sprint

     

    • mohammedadnant's avatar
      mohammedadnant
      Icon for Impactful Individual rankImpactful Individual
      4 years ago

      Hi ABideImen___28 

       

      then try this approach, create 3 master tables and 1 fact table as

      FACT - 1 - detailed table

      DIM - 1 - CLIENT MASTER

      DIM - 2 - PROJECT MASTER

      DIM -3 - SPRINT MASTER - SORT by your requirement

      SPRINT MASTER link with PROJECT MASTER 

      PROJECT MASTER link with CLIENT MASTER

      and 3 DIM link with FACT

       

       

       

      Thanks & Regards,

      Mohammed Adnan

      Learn Power BI: https//www.youtube.com/c/taik18