Create table and populate with measures from other tables (for Radar Chart)

[IoannisT]

Hi Fabric community.

I am trying to create a visual utilising the Radar Chart but I am facing the following problem.

I have multiple tables and in each table I have various measures.

When I poplate them on a matrix, eveything works fine but when I try to apply the same principle on a radar chart, it doesn't work.

My initial though is to create a new table and "drop" the measures for each individual measure.

If I confused you, you are right, here is an image of the problem.

When I use the following static table, I get the right result on top 2 charts. When I use the measures from multiple tables, I get the lower chart.

Category	Budget	Actual	Varience
Apparel	5000	1927	3073
Gifts	1000	4000	-3000
Flowers	1500	2070	-570
Invitation	1500	1156	344
Music	2000	735	1265
Photography	3000	1986	1014
Other Expenses	5000	7590	-2590

-----------------------

Was thinking something like that if possible???

Any ideas?

[v-heq-msft]

Hi @IoannisT ,
Based on your description, if you want to implement putting different measures in different rows, you can try to create a calculation table to summarize this data

Table 2 = 
SUMMARIZE(
    'Table',
    'Table'[Category],
    "Column",
    IF(
        [Category] = "Music",
        [Measure],
        IF(
            'Table'[Category] = "Gifts",
            [Measure 2],
            IF(
                [Category] = "Flowers",
                [Measure 3]
            )
        )
    )
)

Final output

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

[IoannisT]

Hi v-heq-msft

Thanks for your reply.

Unfortunately this method works conditionally only for static values.
If I apply a filter (i.e. trhough a slicer) then the radar chart remains static.

Any ideas?