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.
Hello,
I have an idea to visualise data this way. Does someone know if it's possible to visualise anything like this or similar to it?
It is survey data where you can answer 1 to 5 and then I want to see the average for each question.
My idea:
I hope someone has a good idea 🙂
Solved! Go to Solution.
Hi @Xilitor01 ,
How about creating a custom visual by yourself?
Please refer to the following document for Detailed steps.
https://docs.microsoft.com/en-us/power-bi/developer/visuals/develop-circle-card
Best Regards
Community Support Team _ polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Xilitor01 ,
How about creating a custom visual by yourself?
Please refer to the following document for Detailed steps.
https://docs.microsoft.com/en-us/power-bi/developer/visuals/develop-circle-card
Best Regards
Community Support Team _ polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Polly,
Thank you for your answer.
I think making a custom visual is the best idea for now.
Thank you 🙂
Hello @Xilitor01
The reference file link and image is attached for your quick reference.
https://drive.google.com/file/d/13AB_sAD5Q5ujvk6G9aK3VV_LyY30IItu/view?usp=sharing
Regards
Kumail Raza
If this answers your query, mark it as solution.
Kudos are appreciated 🙂
Hi Kumail,
Thank you for your response.
I am unfortunately unable to open your link as I get an "Access Denied".
Based on your image I might've been unclear.
It should be something like below, but because this is a custom visual I lose a lot of possibilities - like I want it to be dots on a line instead of a bar:
Thank you 🙂
Send your request again.
You need to mention the custom visual that you are looking to use.
@Xilitor01 , Create a table like this
union(
Summarize(Table, Table[Category], "Value", min(Table[Value]), "Type", "Min"),
Summarize(Table, Table[Category], "Value", max(Table[Value]), "Type", "Max"),
Summarize(Table, Table[Category], "Value", Average(Table[Value]), "Type", "Avg")
)
and the create a line/abr visual with axis as Type, Value and Value and Category as small multiple
with no of columns =1
Hi amitchandak,
Thank you very much for your response.
Unfortunatel I get this error:
Some (maybe) useful information:
It is two tables with a DirectQuery whereas the question comes from the one table (SINGLECHOICEQUESTIONVIEW) and the answers come from another table (SINGLECHOICEANSWERVIEW). These are connected on QuestionID.
I hope you can still help me! 🙂
Hello @Xilitor01
If you could send a sample .pbix that demonstrates what you are looking to get. It would really help to provide you with a quick solution.
Regards
Kumail Raza
Hi Kumail,
Thank you for your response.
As this is a DirectQuery I cannot give you a pbix with the exact data. But I have exported the some sample data to Excel and created a pbix file you can download below.
I know it look a little scuffed but I hope you get the idea anyway - please think about a solution that would work on a DirectQuery.
Download pbix here: https://easyupload.io/voh485
Thank you very much! 🙂
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 |
---|---|
102 | |
101 | |
78 | |
69 | |
63 |
User | Count |
---|---|
141 | |
106 | |
101 | |
85 | |
72 |