Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I have 2 questions.
I currently have my data conditionally formatted to turn red if the value is more than 5% as shown below and it works perfectly.
I use the following:
2) I added a column to Datasheet and would like to use it compare to a column in loadlist where is one is more than the other, the tab will turn red.
I used the following:
@Anonymous
One, it should be this:
Background Colour = SWITCH(true(),RELATED('Datasheet'[New column])<'loadlist'[calculated],"red")
Two, for this to work, you will need to change your relationship direction to Both
I got the error message below even after making the changes.
"The column 'Datasheet[New Column]' either doesn't exist or doesn't have a relationship to any table available in the current context."
@Anonymous - Where are you creating this column? Which table?
Apologies I am creating this new column in loadlist to conditionaly format one of the columns in load list.
Thank you
@Anonymous Oh, then it is the reference to loadlist causing the problem, you would need to change the relationship direction between bridge table and load list to be Both
I have changed the relationships to the following
and I still get the following error message:
"The column 'Datasheet[Derated Current]' either doesn't exist or doesn't have a relationship to any table available in the current context."
@Anonymous - OK, never liked RELATED anyway. Try
MAXX(RELATEDTABLE('Datasheet'),[Derated Current])
instead of RELATED.
Great! That works thank you.
But I still can't seem to fix my first issue.
I currently have my data conditionally formatted to turn red if the value is more than 5% as shown below and it works perfectly.
I use the following in Cable Schedule:
Background Colour = SWITCH(true(),'Cable Schedule'[% Volt Drop]>=0.05,"red")
My current table visualisation shows data from Cable Schedule and datasheet and Bridge Table.
However, when I add a new column from loadlist, all my conditional formatting no longer works. How can I fix this?
Hi @Anonymous ,
Based on your description, I have created a sample as your picture shows, but when I add columns from loadlist table into the table visual, the conditional format still works fine.
Maybe you can consider sharing a dummy file for further discussion or modify my sample file which is attached in the below, that could help you better to solve this issue.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
I tried to upload my pbix file but i am unable to.
However, I removed and deleted sensitive data and the formatting came back (really not sure why I cant seem to fix it in my actual file. What is the reason this usually happens?)
But my values appear repeated over and over again.
Hi @Anonymous ,
It seems that the issue could not be determined based on the current table screenshot alone. If you cannot upload the dummy file to the community, you can try to upload it to where can store files such as OneDrive for Business etc. and share the file link here for further discussion.
Best Regards,
Yingjie Li
@Anonymous ,
Try like
SWITCH(true(),RELATED('Datasheet'[New column])<'loadlist'[calculated],"red")
I now get this error message "The column 'Datasheet[Derated Current]' either doesn't exist or doesn't have a relationship to any table available in the current context."
@Anonymous , related will only work from 1-M side
you can bring like this
//from Geography to Sales
City Name = maxx(FILTER(geography,geography[City Id]=Sales[City Id]),geography[City])
//From Sales to Geography
City Name = Sumx(FILTER(Sales,geography[City Id]=Sales[City Id]),Sales[Amount])
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |