Forum Discussion

ASMParDA's avatar
ASMParDA
Frequent Visitor
1 year ago
Solved

Dynamic Column Selection With Mandatory (always selected) column for ID

Hello,    I am hoping someone on here can help me.   The Aim I am aiming to create a very simple dashboard where the end user can select in a slicer (possibly via field parameters) the columns t...
Need Help
  • v-ssriganesh's avatar
    v-ssriganesh
    1 year ago

    Hi ASMParDA,
    Thanks for your detailed explanation and examples and it really helped in reproducing the scenario.

    I’ve implemented your requirement in Power BI using field parameters and a custom DAX measure to conditionally show rows based on whether the selected columns contain non-blank values for each Unique ID. The Unique ID column remains fixed in the visual, and only rows with at least one non-blank value in the selected fields are displayed.

    Example Outcomes (as requested):

    • If the user selects order quantity and delivered quantity, rows with non-blank values in either of those are shown.

    • If the user selects sales volume and sales value, only rows with data in those fields are shown.

     

    For your reference, I’m attaching the working .pbix file so you can explore the implementation directly.


    If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
    Thank you.

v-ssriganesh's avatar
v-ssriganesh
Community Support
1 year ago

Hi ASMParDA,
Thanks for your detailed explanation and examples and it really helped in reproducing the scenario.

I’ve implemented your requirement in Power BI using field parameters and a custom DAX measure to conditionally show rows based on whether the selected columns contain non-blank values for each Unique ID. The Unique ID column remains fixed in the visual, and only rows with at least one non-blank value in the selected fields are displayed.

Example Outcomes (as requested):

  • If the user selects order quantity and delivered quantity, rows with non-blank values in either of those are shown.

  • If the user selects sales volume and sales value, only rows with data in those fields are shown.

 

For your reference, I’m attaching the working .pbix file so you can explore the implementation directly.


If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.