Forum Discussion
Conditional Color based on COUNT for Guage Visual and multiple tables
ANSWERED
Create a NewMeasure to find the difference and then use THAT as the field to base conditional formatting.
-mm
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.
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!
Yes, you may want to invest some time into learning the basics of data modeling in Power BI. The Power BI Desktop App has a Help menu with great links to training material.