Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello,
I have a formula that I was able to create in both Power BI and Excel. However, In Power BI I lost the functionaility that I really needed. Essentially I have all these different methods for which a customer can contact us and the for each method there is a calculation associated with their satisfaction. Essentially in Power BI I would like to be able to replicate what I can do in Excel. Basically, I need to be able to show the question column name and the results for each (this is a net promoter score calculation with a weight associated with it). I would like to be able to show the below numbers and color only those where the count of customers is greater than 50 (as an example) and the green and red colors would be based on the scores provided. Links to the files are below. My big problem is the inability to color code or exclude fields if the response count isn't over a specific number and then color coding the columns individually based on the scores provided.
https://drive.google.com/open?id=1sCdZnJSTtpwWhgGeUXc08wmbkImDAK26
https://drive.google.com/file/d/15iHZiuEb0MQt_OkAWYB9Yu-R9blg-1oX/view?usp=sharing
Hello,
I have a formula that I was able to create in both Power BI and Excel. However, In Power BI I lost the functionaility that I really needed. Essentially I have all these different methods for which a customer can contact us and the for each method there is a calculation associated with their satisfaction. Essentially in Power BI I would like to be able to replicate what I can do in Excel. Basically, I need to be able to show the question column name and the results for each (this is a net promoter score calculation with a weight associated with it). I would like to be able to show the below numbers and color only those where the count of customers is greater than 50 (as an example) and the green and red colors would be based on the scores provided. Links to the files are below. My big problem is the inability to color code or exclude fields if the response count isn't over a specific number and then color coding the columns individually based on the scores provided. Please note, the main thing is that I need to figure out how I can leverage the conditional formatting for the color requirement. Even if the process is manual that is OK also!
https://drive.google.com/open?id=1sCdZnJSTtpwWhgGeUXc08wmbkImDAK26
https://drive.google.com/file/d/15iHZiuEb0MQt_OkAWYB9Yu-R9blg-1oX/view?usp=sharing
Hi @nmckbcs
Just provided solution in another thread, i hope you will get an idea if you refer this.
Thanks
Raj
It makes a little sense but would need to know how to apply that to my issue. Any suggestions?
Can you explain what issue you are facing in conditional formatting? As per your email, you are able to get the values and you can do formatting for each column based on the value.....
Thanks
Raj
Hi @nmckbcs,
I would suggest you transform your data structure then it would be easy. Please refer to the demo in the attachment.
Best Regards,
Dale
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
106 | |
95 | |
38 | |
33 |
User | Count |
---|---|
152 | |
122 | |
76 | |
74 | |
47 |