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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
sergioquerido
Frequent Visitor

Segmentation of data not working with a Radar Chart (Unpivoted table)

Hello,

 

I have a radar chart from an unpivoted table ("Unpivoted RealxExpected") that is linked with the main table ("GPS") from the variable "Date" (as oberserved in figure attached bellow, chart with the title "Suggested and Performed Workload"). However, there is another variable that is an important relation between tables ("Unit Number"), because, the same day may has different sessions, with different numbers.

So, how can i change the code of table "Unpivoted RealxExpected" to be able to respond to the data segmentation of "Date" and "Unit Number" (with title "Session")?

 

Captura de ecrã 2024-02-13, às 16.05.47.png

 

To be easyer to understand and work in the issue, i also attache the .pbix file in the following link:

 

https://home.mycloud.com/action/share/027f1eda-b1ef-4486-980b-f1733297919c

 

Thank you!

SMQ

 

 

 

1 ACCEPTED SOLUTION
sergioquerido
Frequent Visitor

With the help of a friend, we solved the issue creating 2 new tables, one with "dates" (0DateFilter) and other with "sessions" (0SessonFilter), from the main table "GPS" (GPS[Date] and GPS[Unit Number]) and changed the active relations as in attached figure.

Thank you.

Captura de ecrã 2024-02-14, às 16.37.35.png

 

View solution in original post

3 REPLIES 3
sergioquerido
Frequent Visitor

With the help of a friend, we solved the issue creating 2 new tables, one with "dates" (0DateFilter) and other with "sessions" (0SessonFilter), from the main table "GPS" (GPS[Date] and GPS[Unit Number]) and changed the active relations as in attached figure.

Thank you.

Captura de ecrã 2024-02-14, às 16.37.35.png

 

v-heq-msft
Community Support
Community Support

Hi @sergioquerido ,
Based on your description, you need to modify the "Unpivoted RealxExpected" table to include a composite key that combines these two fields.Open the Power Query editor. Add a custom column that concatenates the Date and Unit Number to create a unique identifier for each session. Again, make sure there is a column in the "GPS" table that joins the "Date" and "Unit Number" in the same format as the "Unpivoted RealxExpected" table. In Power BI Desktop, go to the Modeling tab and select Manage Relationships. Create a new relationship using the composite keys created in both tables.


Best regards,

Albert He

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

@v-heq-msft thank you for your response. The Unpivoted RealxExpected is a table created by DAX code, is not possible to edit in Power Query editor. I need to find a solution based on DAX.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.