Forum Discussion

Zakaria_1980's avatar
Zakaria_1980
Icon for Post Patron rankPost 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
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
    Icon for Post Patron rankPost Patron
    3 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      I do not have access to this location. Possible make a public sharepoint?

      • Zakaria_1980's avatar
        Zakaria_1980
        Icon for Post Patron rankPost Patron
        3 years ago

        can you check please now

        thanks.