Rookie data modelling issues

[MichelleR]

Hi! I am a newbie in Power BI so please bear with me. I have been stuck on this and can't figure it out so please help!

I have a model with multiple dimensions, each representing a column:
Account (sales, expenses, other)

Requirement (A,B,C,D, E)

Tool (spoon fork knife)

and a value column.

Tool	Account	Requirements	Value
Spoon	Sales	A	1
Spoon	Sales	A	2
Fork	Sales	B	3
Fork	Expenses	C	4
Fork	Expenses	D	5
Knife	Expenses	E	5
Knife	Other	A	6
Knife	Other	A	7

I have this data as an excel file and I have uploaded it to Power BI Desktop. Now I actually have more than one thing I can't understand and I think it's related:

A)  what is the best way to model this data so that i can put on the same chart two of the requirements: A on the x and B on the y axe? I currently have them all under requirements and can't put requirement on both axes.

B) I want to create a radar chart in which the requirements are at the angles of the pentagon and each tool is represented individually with a spider web. Since now all tools are under the tool field, I can't seem to show them together. (I have downloaded the Radar Chart 2.0.2).

To give you a general idea of what i am trying to achieve:

 

I sincerely hope you can understand my issue and are able to help me. Thanks in advance

[Anonymous · Accepted solution]

HI @MichelleR,

#1, So you mean you want to have a visual with configurable visual axes based on user operation/selection?

If that is the case, I'd like to suggest you create two calculated tables with all requirement types and use them on axis and legend. For the value part, you can write a measure expression to look up and calculate the value from the raw table based on current axis values.

Using the SELECTEDVALUE function in DAX 

#2, Your data structure seems not able to direct achieve the graph on radar visual. I'd like to suggest you use the 'requirement' field on category and write measure expressions to calculate different tool types and use on y-axis field.

Sample:

Spoon =
CALCULATE (
    SUM ( 'Table'[Value] ),
    FILTER ( ALLSELECTED ( 'Table' ), [Tool] = "Spoon" ),
    VALUES ( 'Table'[Requirements] )
)

Regards,

Xiaoxin Sheng

[MichelleR]

Thank you! Measure expressions are exactly the solution I was looking for but since I am new to this tool I didn't even know they existed. Problem solved 😄

[negi007]

@MichelleR will it be possible for you to share your data in text format or excel format. You can share dummy data with acutal columns so that we can have a look at it and test it at our end. Also, you can test it in the excel as well as there is an option to create radar chart.

[MichelleR]

Okay so I tried adding more infos, does this help?