Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
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 used the following:
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 ,
When you drag the table visual down,you will see the formatting works:
Yeap the conditional formatting works when I remove my sensitive data I am not sure why.
Hoever, the data in the table keeps repeating itself and I am unable to fix that.
Thank you.
Hi @Anonymous ,
If you add the sensitive data,will the data with contional formatting still exists in the table visual?I'm guessing it's not a contional formatting issue,but a table relationship issue...
I would think so too. Maybe if the issue of the multiple rowa appearing is solved, the conditional formatting will appear fine too? The issue I'm having now is the multiple repeated rows.
Thanks.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
The number is fine and appears as it should however, the conditional formatting no longer works and I can't seem to figure out why.
I tried doing a Bridge Table in power query and it made the values of my load list column appear repeatedly for every single row.
I tried to solve it in this thread https://community.powerbi.com/t5/Desktop/See-all-rows-in-tabel-visualisation/td-p/1350674 and still cant seem to solve the many-to-many issue.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
What are the changes that I would have to make to change it into a measure as the DAX doesn't seem to work as a measure and get this error message when I try to change the Background Colour into a measure:
@Anonymous
1) Your measure error stems from the fact that you have many rows for Volt drop for the same Cable number. In the pbix file you uploaded, your table visual is doing a SUM on these values, so you could try adding SUM() function to your DAX when turning it into a measure:
% Volt Drop Measure = SUMX('Cable Schedule',((RELATED(Datasheet[Volt Drop])*'Cable Schedule'[Load]*'Cable Schedule'[Length Metres])/100)/500)
2) You can use the built in conditional formatting on the matrix to apply it to the measure directly (no need for custom DAX for the formatting, it can be done using the Power BI tool).
3) In your sample data, these are the Tags/Cable Numbers that have more than one rate value:
As I mentioned in 1) above, your sample pbix is doing a SUM on the %VOLT drop, but what is the intended result when there is more than 1 value for Rate in the Full List table?
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
1) % Volt Drop Measure = SUMX('Cable Schedule',((RELATED(Datasheet[Volt Drop])*'Cable Schedule'[Load]*'Cable Schedule'[Length Metres])/100)/500).
I tried it out and my values appear as 0.
I find it odd as for S/N 1-5, there is no cable number, hence I was expecting the cable rates to be blank and not have repeated rows.
3) Is there a way to show it the same number of times it appears? ie. A10A_3LLNPPA11A01 shows up twice once for 63 and once for 200? They are sub sections of the same cable number which I deleted the column as it contains sensitive data.
Really appreciate you trying to help.
Thank you.
Hi @Anonymous ,
Could you pls upload your .pbix file to onedrive business and share the link with us?(Remember to remove the confidential information).
Hi there,
It can be found in the link below. I removed sensitive data and the conditional formatting works (my actual one still doesn't) but my data still appears repeatedly and I can't seem to solve that.
Thank you.
Hi @Anonymous ,
The link you provided is not public and I dont have access to it,pls make a public link and share it with me.
Apologies about that.
Here it is: https://entuedu-my.sharepoint.com/:u:/g/personal/amya0001_e_ntu_edu_sg/EQQWgMXzwvpBh8uGZ7_noOABcjUGM...
Should work now.
Thank you.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |