Suppress 0 in Field Parameters
Hi guys, just wondering if you can help me with this... I created a field paramter based on two measures and added a bar-chart which now shows a lot of 0 values. In the filter pane I tried to exlude 0 and or blanks etc but it doesn't work as it will hide the content of the other field parameter. Example below: Dax Measure that causes the problem is the following: I tried both versions, but it does not change the outcome of the output. Admin = [Total Inspections]-[Physical] or Admin = IF ( ISBLANK ([Total Inspections] ), BLANK (), ( [Total Inspections]-[Physical] ) ) Field Parameter: Physical/Admin Slicer = { ("Physical", NAMEOF('Power BI - Inspections'[Physical]), 0), ("Admin", NAMEOF('Power BI - Inspections'[Admin]), 1) } This only happens when the Admin Slicer is selected. I can choose to not select 0 in the filter pane, but that hides all the Physical values then when Physical is selected. Thanks for your help.
Field Parameters in Report Server
Hello everyone! Recently I have discovered Field Parameters feature in Power BI, which helped to replace tens of matrices to just one, that can be customized for every employee, using this report. Unfortunately, this feature is unavailable at RS version, which is used by company. Is there any information, when this feature will be released? Or any other ways to make matrices visualizations with custom rows? Thanks!
Dynamic Field in Slicer based on Field Parameter selection
Hi PBI Community I have been stuck for a while on trying to build upon my Field Parameter into a slicer. I have a Field Parameter that switches between four columns (Min Quantity, Max Quantity, Avg Quantity, Confirmed Quantity). I need a Slicer / Filter that is populated by the field (4 columns, Min Price, Max Price, Avg Price, Confirmed Price), based on the selection in the field parameter. So e.g, if i were to select "Min Quantity" in my Field Parameter, the slicer would contain the "Min Price" column and so forth. I have looked into combining IF() and SWITCH(), but the Slicer won't accept the measures i have created as valid. All help is appreciated. Kind regards, Andreas
Custom text for parameter table
I have created a table with fields parameter and using this in a slicer. DAX is a follows : Tabular Options - Summary = { ("vs LY", NAMEOF('Measure Folders'[Value Options formatted ( Summary )]), 0), ("Selected Perspective", NAMEOF('Measure Folders'[Selected Perspective]), 1), ("LY Actuals", NAMEOF('Measure Folders'[LY]), 2), ("vs AOP", NAMEOF('Measure Folders'[Value Options formatted ( Summary )(AOP)]), 3), ("AOP Actuals", NAMEOF('Measure Folders'[AOP]), 4) } Now I want to change the title based on user selection. Like in the "vs LY", I want to show "vs 2022" when user selects year 2023 from fact table. Is it possible?
How to use DAX formula SELECTEDVALUE with Field Parameters
Dear Power BI community, I would like to ask for your help as I am trying to use DAX formula SELECTEDVALUE based on field parameters, however it is not doable based on the following error message: IF user selects between two value the (Amount USD & Amount LCL) the calculation should be changing based on that: DAX formula : Field Parameter: Visualization selection for Amount USD & Amount LCL: Would it be possible for someone to help how to change the DAX formula SELECTEDVALUE part to make it work? Thank you for your advice in advance. Wishing you a wonderful date. Adam
