Forum Discussion
Field Parameter Work Around
- Anonymous2 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 CountsHow 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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
https://youtu.be/fNzbddt7t2E