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 that Gates is achieved and let others in light blue color.

for Project#2, it reached G6, so for sure all previous gates were achieved too.

for project#3, it reached G5, which mean only G4 & G5 are completed and they should be in dark blue and G6 in light blue.

 

 

i appreciate if you could send me the PBI file.

thx

 

12 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    To be honest this seems like a request for us to make u a visual? This community is for support on what u can do yourself. We are helpers not workers.

    • Anonymous's avatar
      Anonymous
      Not applicable

      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

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Still not, I requested access see your email.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Sorry i cannot get the desired outcome personally.