Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
no one please can help me
?
Sorry i cannot get the desired outcome personally.
I've granted you access , can you check please ?
Thank you.
Still not, I requested access see your email.
Appreciated this quick feedback ... !!!!!
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.
The issue mainly is u not using integer for gate numbers. Otherwise u can easily do the colouring via conditional formatting aswell.
I do not have access to this location. Possible make a public sharepoint?
can you check please now
thanks.
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.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |