Dynamic Axis and legend without Field Parameters

Hi EduardoCastulo 

Here is my approach, though i would insit that you share sample data that woule have made soultion easy. 

Here are steps that i have taken.

Here is my sample data (This sould will only work when you have primary key in the data else this will not work).

i have taken addional column deparment to test my solution.

Now you need to create a summry table using this dax function. 

SummaryTable =

VAR ProductsTable =

    SELECTCOLUMNS(

        'table',

        "id", 'table'[Unique ID],

        "column", "Product",

        "column value", 'table'[Product Name],

        "sales", 'table'[Sales]

    )

VAR CountriesTable =

    SELECTCOLUMNS(

        'table',

        "id", 'table'[Unique ID],

        "column", "Country",

        "column value", 'table'[Country of origin],

        "sales", 'table'[Sales]

    )

RETURN

    UNION(ProductsTable, CountriesTable)

 

and than make a connect using primary key i.e. ID once it done create a slicer for both the column and it should be single select.

If you see it works only contrainst us you need primary key, and you have only single select slicer else value would be incorrect. 

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

Regards