Forum Discussion

NSKD's avatar
NSKD
New Member
1 year ago
Solved

Greater Than for Prioritisation system

Hello,

 

I'd like to prepare a prioritisation matrix similar to the example image at the bottom of this post. My data includes an excel table titled 'Priorities' which has an inbuilt scoring system for projects. See image below where I have highlighted the score column.

 

I'd like to present this data in the graph, using a greater than formula.

 

E.g. projects with a score >=75 are a high priority. 

projects with a score >=50 are a medium priority. 

etc.

 

Could someone please assist me with this? I am a beginner so a simple and complete explanation is appreciated!

 

Thank you

 

 

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, NSKD 

    Thanks for Ashish_Mathur's reply. You can try to use following dax to achieve your need.

    In Report View:
    Choose a table name and right-click, click the New Column button, then input the dax to create a new column.

     

    Column = 
SWITCH(
    TRUE(),
    'Table'[Score]>=75,"High",
    'Table'[Score]>=50,"Medium",
    "low"
)

     


    In Power Query: Click Custom Column and input the following M Language

     

    if [Score] >= 75 then "High" else if [Score] >= 50 then "Medium" else "Low"

     

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know.     Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

8 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    1 year ago

    Hi,

    I am not sure whether you will be able to build a prioritisation matrix with this suggestion but create a calculated column formula

    Column = if(Priorities[Score]>=75,"High",if(Priorities[Score]>=75,"Medium","Low"))

    Hope this helps.

    • NSKD's avatar
      NSKD
      New Member
      1 year ago

      Hi Ashish,


      Thanks for your comment. I keep running into errors when I try similar formulas.

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, NSKD 

    Thanks for Ashish_Mathur's reply. You can try to use following dax to achieve your need.

    In Report View:
    Choose a table name and right-click, click the New Column button, then input the dax to create a new column.

     

    Column = 
SWITCH(
    TRUE(),
    'Table'[Score]>=75,"High",
    'Table'[Score]>=50,"Medium",
    "low"
)

     


    In Power Query: Click Custom Column and input the following M Language

     

    if [Score] >= 75 then "High" else if [Score] >= 50 then "Medium" else "Low"

     

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know.     Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum