Line chart 2D plot

[Anonymous]

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 🙂

[Anonymous · Accepted solution]

Hi @Anonymous ,

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.

[Anonymous]

Hi Polly,

Thank you for your answer.

I think making a custom visual is the best idea for now.

Thank you 🙂

[Kumail]

Hello @Anonymous 

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 🙂

[Anonymous]

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 🙂

[Kumail]

Send your request again.

You need to mention the custom visual that you are looking to use.

[amitchandak]

@Anonymous , 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

[Anonymous]

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! 🙂

[Kumail]

Hello @Anonymous 

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

[Anonymous]

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! 🙂