Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DAX Query With Switch & IF Condition Misbehaves - Power BI

I tried with below DAX queries to control the color of a rectangle shape. Both the queries are making the rectangle white color for blank values and other some values too. What would be the reason an...
Need Help
Show and Tell
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey Anonymous ,

 

there are a few issues with your report.

Your slicer is filtering on the column 'pjrep MSP_EpmProject_UserView'[ProjectUID] that has 491 IDs.

You added the column with the color to the column 'PlannedPayment'[ProjectUID] that has 154 IDs.

 

That means you just defined a color for 154 IDs and in the report you can filter 491 IDs. So at least 337 IDs that you chose from the list don't have a color defined. For these colors the background will stay white.

 

For the color you chose the first value of the column COSTIndicatorColor. So if you have multiple values selected as you mentioned a random/the first color in the current selection will be chosen.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey Anonymous ,


could you fix your issues with the information from my last post?

I'm curious if you could solve this issue 🙂

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis