Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Tooltip Showing Null Columns

Hello All, I've built a dashboard to audit how much data has or has not been populated in a Project Online site. I'm able to pull all the info and graph percentage of data populated. What I'd like t...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous

     

    You may refer to below sample data and create a measure like:

    Measure =
CONCATENATEX ( FILTER ( Table3, Table3[Value] = "" ), Table3[Attribute], "&" )

     

    Regards,

    Cherie

Anonymous's avatar
Anonymous
Not applicable
7 years ago

v-cherch-msft,

I briefly looked at unpivot and now it makes sense why you've suggested that. I'll play around with the feature a bit today to see what I can mangage. Thank you again for the input!

 

Forti4040

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous

 

You may refer to below sample data and create a measure like:

Measure =
CONCATENATEX ( FILTER ( Table3, Table3[Value] = "" ), Table3[Attribute], "&" )

 

Regards,

Cherie

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    v-cherch-msft,

    Thank you again for the great insights! I can certainly see where you are heading with this and it makes sense how it would work. Being new to the unpivot feature I am a bit confused as to how I can utilize it without impacting the rest of my report data. When I unpivot data it duplicates rows and messes up a bunch of the formulas. Is the intent that I would create a duplicate table that is somehow reading from the original and doing the unpivot action there? This way it keeps the original data intact but has an unpivoted section that I can pull from?

     

    I feel like once I wrap my head fully around the unpivot issues you will have completely solved my issue!

     

    Regards,

    Forti4040

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      v-cherch-msft,

      I did some more digging and figured out the rest. I created a reference table to my original data to work with and that was part of the trick. The other thing I found was that unpivoting actually removed the blanks from my data so I had to replace blanks with a value, unpivot, then replace the value with blanks again. But I've got it running now thanks to you!