Forum Discussion

EduardoCastulo's avatar
EduardoCastulo
New Member
2 years ago

Dynamic Axis and legend without Field Parameters

Hi community!

I am looking for a way to create or simulate the Field Parameters feature in my report. I've been searching all week and haven't found a solution. I am working with Power BI Report Server, and this feature is disabled by admin.

I have a single table named "Total Sales" which includes fields such as USD, Product Name, and Country of Origin, among others. I want to use this table in a "Stacked Bar Chart," with the x-axis showing the sum of USD and the y-axis showing either Product Name or Country of Origin.

The main issue is with the y-axis. I found that Field Parameters would perfectly achieve my objective, but with this limitation, I wonder if there is another workaround to achieve this.

Thanks!
Eduardo R.

1 Reply

  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    Solution Sage
    2 years ago

    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