Forum Discussion

AndHld's avatar
AndHld
New Member
2 years ago

Field parameter filtering

Hi, I just recently discovered field parameter feature in Power BI and found it quite useful, but I'm a bit stuck with filtering options even if it possile at all to filter one of the dimensions w...
Need Help
AndHld's avatar
AndHld
New Member
2 years ago

amitchandak Thanks, I didn't know that Field parameter is not accepting SELECTEDVALUE function, it was one of my possible approaches. So far I came up this:
Parameter selector:

Selected Param = MAXX(
    FILTER(
        Parameter,
        Parameter[Parameter Order] =
        SELECTEDVALUE(
            Parameter[Parameter Order]
        )
    ),
    Parameter[Parameter]
)
And than I tried to plot on this measure insted of regular total:
TTL BKG = IF(
    [Selected Param] = "Corporate Name",
    CALCULATE(
        SUM(Sheet1[Sum of Bkg CW CY]),
        TOPN(
            10,
            Sheet1,
            SUM(Sheet1[Sum of Bkg CW CY]),
            DESC
        )
    ),
    SUM(Sheet1[Sum of Bkg CW CY])
)
But no luck so far, it still plots all of possible names.
Thanks anyway!
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, AndHld 

    May I ask if you have gotten this issue resolved? If it is solved, please share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.


    If it is not resolved, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. We will do our best to provide ideas for your issue.

     

     

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Fen Ling,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • AndHld's avatar
      AndHld
      New Member
      1 year ago

      Hi, actually I didn't I gave up and put top 10 as a separate chart.
      There is an example .pbix attached (downloadable via link in original post)

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi, AndHld 

         

        Unfortunately because of security protocols we are unable to view and download the pbix file you shared before. 

         

        Here are the relevant links that we hope you will find helpful: 

        How to provide sample data in the Power BI Forum - Microsoft Fabric Community

        Solved: How to upload PBI in Community - Microsoft Fabric Community

         

        Please be careful to remove all sensitive information and we will do our best to provide ideas for your issue.

         

         

        I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
        Best Regards,
        Fen Ling,
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.