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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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