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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors