Forum Discussion

Mmench's avatar
Mmench
Regular Visitor
2 years ago
Solved

Conditional Color based on COUNT for Guage Visual and multiple tables

I'm trying to show a visual of authorized position for multiple locations vs actual.    RESULTS: RED gradient for 'under manned' and GREEN gradient for 'overmanned' and WHITE if authorized equals m...
"COUNT"
@Conditional Formatting
  • Mmench's avatar
    Mmench
    2 years ago

    ANSWERED

     

    Create a NewMeasure to find the difference and then use THAT as the field to base conditional formatting.

     

    -mm

lbendlin's avatar
lbendlin
Super User
2 years ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

  • Mmench's avatar
    Mmench
    Regular Visitor
    2 years ago

    Thanks...  hopefully this works.

    I've only listed a few of the jobs on the page with all the gauges, so some of the locations will be blank.

     

    Again, instead of BLUR I'd love to see RED for Assigned less than Authorized, White for equal to, and GREEN for Assigned greater than Authorized. If there was a way to make it a gradient based on % that would be super!


    also... Any visual is ok if it works.  I've used NewCards instead of guage here, too.

    let me know if this doesn't work.  Thanks again. -mm

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      Your data model is not in a usable shape

       

      which table is the dimension and which is the fact? You may need to have additional dimensions like Location.

       

      • Mmench's avatar
        Mmench
        Regular Visitor
        2 years ago

        Hey, thanks.  

        AUTHORIZATIONS table is the current allowable number of jobs (SPACES), while the MASTER DATA (FACES) is the positions manned by actual people.  Not sure which would be defined as dimension or fact. Spaces vs Faces is the only way I know to describe it.

         

        I think this is my whole problem.  Maybe I'm in the wrong forum?  I hate to say that I don't know what you are asking.  Currently they are linked by LOCATION.


        Maybe I need a new table for the formula, I really don't know what I need to do first to get what I want.  I thought it could be as easy as creating a conditional.

         

        ii hoped there was a  formula that I could do something like...

         

        = COUNT(tableA[columnX]-tableB[columnY]), "difference"

        IF "difference"<0, "RED" .. >0, "BLUE" .. =0, "WHITE"

         

        I do appreciate any help or pointing me in a good direction.  Thx!