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

[sergioquerido]

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")?

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

[sergioquerido · Accepted solution]

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.

[v-heq-msft]

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

[sergioquerido]

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