Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Top N in Power BI Service

Hello Experts,

 

Attached picture is a visual level filter from the app in Power BI Service. When Selecting the Top N option in the filter, from where should I add the field to the 'By Value' option? In desktop, we can drag and drop from the datasets, but in Service, from where do I select the field? If it's not at all possible, so why MS has given this option to add the value even in app? 

 

 

Thanks and Regards,

Anirban

Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    You can't edit the report in the APP, this is not allowed. You should d like this.

    1. Edit the report in the workspace.

    2. Update the APP.

     

    Or do you want report viewers to change that field by themselves?

    This is currently not possible, and this field can only be changed in the editing state of the report.

     

    Best regards,
    Lionel Chen

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

3 Replies

  • nandukrishnavs's avatar
    nandukrishnavs
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous 

     

    When you edit the report in Power BI service, you will see fields on the right side. (similar to Power BI desktop)

    From the field section, you can drag the column/measure into the By value field.

     

    I tried it in Power BI service (Internet Explorer) and it is working fine. Refer to the below snapshot.

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello nandukrishnavs , thanks for replying.

       

      I can see the fields in Edit report page, but I am referring to the app page where there is no edit option and there is no fields visible to drag to that field. The MS has given that option to the report consumers (viewer/contributors) to select Top N value in app as well. I was trying to explore that option in app, not in edit report option. 

       

      Regards,

      Anirban

      • v-lionel-msft's avatar
        v-lionel-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,

         

        You can't edit the report in the APP, this is not allowed. You should d like this.

        1. Edit the report in the workspace.

        2. Update the APP.

         

        Or do you want report viewers to change that field by themselves?

        This is currently not possible, and this field can only be changed in the editing state of the report.

         

        Best regards,
        Lionel Chen

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