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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
sergioquerido
Frequent Visitor

Radar Chart form Unpivoted table not responding to Filter Date

Hello,

 

As observed in figure bellow, I have 2 Radar Charts with 3 measures (anchor of 100%, mean of all all players, and values of player) from a unpivoted table. However, the measures, in particular the values for each player filtered, are not responding to the filter date (range between two dates). How to solve this problem? 

 

Captura de ecrã 2023-12-29, às 19.26.07.png

Here an example of original database:
Captura de ecrã 2023-12-29, às 20.01.34.png

 

The code of one Unpivoted Table:

UnpivotedTable_Defensive = 
VAR _ORIGINAL =
ADDCOLUMNS(SUMMARIZE(Stats, Stats[Player], Stats[Cluster]),
     "Coordinates Defensive Duels", 1,
     "Coordinates Aerial Duels", 1,
     "Coordinates Loose Ball Duels", 1,
     "Coordinates Sliding Tackles", 1,
     "Coordinates Recoveries Opponent Half", 1,
     "Coordinates Back Passes", 1,

     "Player Defensive Duels", Stats[%_SummPlayerDefensiveDuels],
     "Player Aerial Duels", Stats[%_SummPlayerAerialDuels],
     "Player Loose Ball Duels", Stats[%_SummPlayerLooseBallDuels],
     "Player Sliding Tackles", Stats[%_SummPlayerSlidingTackles],
     "Player Recoveries Opponent Half", Stats[%_SummPlayerRecoveriesOpponentHalf],
     "Player Back Passes", Stats[%_SummPlayerBackPasses],
     
     "Mean Defensive Duels", Stats[%_SummClusterDefensiveDuels],
     "Mean Aerial Duels", Stats[%_SummClusterAerialDuelds],
     "Mean Loose Ball Duels", Stats[%_SummClusterLooseBallDuels],
     "Mean Sliding Tackles", Stats[%_SummClusterSlidingTackles],
     "Mean Recoveries Opponent Half", Stats[%_SummClusterRecoveryOpponentHalf],
     "Mean Back Passes", Stats[%_SummClusterBackPasses])

VAR _TABLE1 =
    SELECTCOLUMNS (
        _ORIGINAL,
        "Player", Stats[Player],
        "Variable", "Defensive Duels",
        "Coordinates", [Coordinates Defensive Duels],
        "Player Stats", [Player Defensive Duels],
        "Mean", [Mean Defensive Duels])

VAR _TABLE2 =
    SELECTCOLUMNS (
        _ORIGINAL,
        "Player", Stats[Player],
        "Variable", "Aerial Duels",
        "Coordinates", [Coordinates Aerial Duels],
        "Player Stats", [Player Aerial Duels],
        "Mean", [Mean Aerial Duels])

VAR _TABLE3 =
    SELECTCOLUMNS (
        _ORIGINAL,
        "Player", Stats[Player],
        "Variable", "Loose Ball Duels",
        "Coordinates", [Coordinates Loose Ball Duels],
        "Player Stats", [Player Loose Ball Duels],
        "Mean", [Mean Loose Ball Duels])

VAR _TABLE4 =
    SELECTCOLUMNS (
        _ORIGINAL,
        "Player", Stats[Player],
        "Variable", "Sliding Tackles",
        "Coordinates", [Coordinates Sliding Tackles],
        "Player Stats", [Player Sliding Tackles],
        "Mean", [Mean Sliding Tackles])

VAR _TABLE5 =
    SELECTCOLUMNS (
        _ORIGINAL,
        "Player", Stats[Player],
        "Variable", "Recoveries Opponent Half",
        "Coordinates", [Coordinates Recoveries Opponent Half],
        "Player Stats", [Player Recoveries Opponent Half],
        "Mean", [Mean Recoveries Opponent Half])

VAR _TABLE6 =
    SELECTCOLUMNS (
        _ORIGINAL,
        "Player", Stats[Player],
        "Variable", "Back Passes",
        "Coordinates", [Coordinates Back Passes],
        "Player Stats", [Player Back Passes],
        "Mean", [Mean Back Passes])


RETURN
    UNION ( _TABLE1, _TABLE2, _TABLE3, _TABLE4, _TABLE5, _TABLE6)

Example of the code for measure "Player Defensive Duels":

%_SummPlayerDefensiveDuels = CALCULATE(AVERAGEX(SUMMARIZE (Stats, Stats[Player]), CALCULATE(AVERAGE(Stats[%_DefensiveDuels]))))

Example of the code for measure "Mean Defensive Duels":

%_SummClusterDefensiveDuels = CALCULATE(AVERAGEX(SUMMARIZE (Stats, Stats[Player], Stats[Cluster]), CALCULATE(AVERAGE(Stats[%_DefensiveDuels]), VALUES(Stats[Cluster]))), ALL(Stats[Player]))

 

 

Thank you!

1 REPLY 1
lbendlin
Super User
Super User

Please show how you linked your stats table to your calendar table.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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