Forum Discussion

Zakaria_1980's avatar
Zakaria_1980
Post Patron
3 years ago

support needed please

Hi, I have the below DB, projectId Vs Completed gates. i need in powerBi to put the PorjectIds in filter. so if I select Project#1 he will show me the 3 cubes but the cube will be in dark blue if th...
Need Help
Zakaria_1980's avatar
Zakaria_1980
Post Patron
3 years ago

Appreciated this quick feedback ... !!!!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I will help you on the way.
    U will need a "Slicer" which holds project_id
    U will need a card which holds completed_gate (Make background etc invisible to only show text)
    U will need to add a Shape(Any of your choice. They don't have diamond so u can pick to make 2 triangles look like one or use a different one.)


    U will want to go to selections and make the shape below any visuals.
    This will show u the completed gate based on project ID.
    How to show the underlying already completed statusses is unknown to me since u use G4, G5, G6 instead of just 4,5,6. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      The issue mainly is u not using integer for gate numbers. Otherwise u can easily do the colouring via conditional formatting aswell.

      • Zakaria_1980's avatar
        Zakaria_1980
        Post Patron
        3 years ago

        PBI Example attached if you can please support. i put the gates now as integer