Forum Discussion

STEFAN_SA's avatar
STEFAN_SA
Regular Visitor
2 years ago
Solved

Field Parameter Work Around

Good Day All I hope you can advice me on a way to use DAX to create a Field Parameter like function. I want to use a bar or column chart to display the total counts per User based on a paramter I...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi STEFAN_SA ,

    It seems that you want to put the measure on the axis.

    I have found a document about using the measure as axis in the visual. Please refer to it.

    The workaround of using the measure as axis in the... - Microsoft Fabric Community

     

    Or Instead of trying to dynamically switch the user dimension on the y-axis, use your slicer to dynamically adjust the measure (counts) displayed on the x-axis. This measure can be something like:

    Dynamic User Counts =
    VAR SelectedStageID = SELECTEDVALUE(('(Slicer)_OperationStages'[ID]))
    RETURN
    SWITCH(
    SelectedStageID,
    1, [TotalCountsAll], -- Assuming [TotalCountsAll] is a measure for all stages
    2, [TotalCountsAcknowledged],
    3, [TotalCountsPhoned],
    -- Add other cases as necessary
    BLANK() -- Default or error case
    )


    Visual Setup: Use your users dimension on the y-axis and the measure on the x-axis of your bar chart. This setup should allow the counts to dynamically adjust based on the slicer selection, while consistently displaying users on the y-axis.Dynamic User Counts

     

     

    How to Get Your Question Answered Quickly - Microsoft Fabric Community

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.