support needed please

[Zakaria_1980]

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

[Zakaria_1980]

no one please can help me

?

[Anonymous]

Sorry i cannot get the desired outcome personally.

[Zakaria_1980]

I've granted you access , can you check please ?

Thank you.

[Zakaria_1980]

powerbi report 

[Anonymous]

Still not, I requested access see your email.

[Zakaria_1980]

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

[Anonymous]

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]

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

[Zakaria_1980]

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

[Anonymous]

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

[Zakaria_1980]

can you check please now

thanks.

[Anonymous]

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.