Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear all,
I have been playing around with PowerBI for some time but there is one thing I'm still struggling with.
The situation
I created a Microsoft Forms questionnaire in which I ask five different multiple choice questions. The possible answers are "perfect", "good", "mediocre" and"bad". These are mandatory questions where only one answer can be given. I connected the Form with Flow to PowerBI and simple elements such as a bar chart and a pie chart are working perfectly. However, I would like to indicate with the custom visual tachometer what the percentage of answers "perfect" and "good" are compared to the total amount of answers.
The problem
I am unable to only show the "perfect" and "good" answers without also filtering the total amount of answers. As a result it is always showing 100% on the tachometer.
I hope that I provided enough information, otherwise I'm happy to elaborate.
Kindest regards and thanks for the help
Solved! Go to Solution.
Thanks for the help everyone!
The solution is to create a second table. This way the tacho can be filtered individually for each table.
Hi @SusD,
Please share some dummy data and expected results to help us clarify your data structure and do test on them.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Let's assume the following:
There is one multiple choice question where someone can choose between the following options;
The goal of the tachometer is to illustrate how many times option 1 and 2 is selected compared to the total times an answer was given. Taken the above data into account, I want to have a dial at 75% indicating the percentage of option 1 and 2 combined. The purpose of the tachometer is to illustrate the level of service provisions that is at least 80%. Currently, I can't build the tacho in a way that it shows only option 1 and 2 for the value. It is also included in the total meaning that it is always 100%
Hope this helps and thank you very much for the support
Thanks for the help everyone!
The solution is to create a second table. This way the tacho can be filtered individually for each table.
@SusD , you have created a % measure. or what measure you are using
I'm not completely sure. In the database the input is considered text.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |