Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
MichelleR
Frequent Visitor

Rookie data modelling issues

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.

 

ToolAccountRequirementsValue
SpoonSalesA1
SpoonSalesA2
ForkSalesB3
ForkExpensesC4
ForkExpensesD5
KnifeExpensesE5
KnifeOtherA6
KnifeOtherA7

 

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:

Untitled.png

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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] )
)

 

13.png

Regards,

Xiaoxin Sheng

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

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] )
)

 

13.png

Regards,

Xiaoxin Sheng

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
Community Champion
Community Champion

@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.




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

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

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.