Forum Discussion

Jessica_17's avatar
Jessica_17
Helper V
1 year ago
Solved

User input for each row

I have a table with two columns: Category (Col A) Price (Col B) I want to create a stacked bar chart using these columns. However, the key requirement is that the order of the category legends in...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-achippa's avatar
    v-achippa
    1 year ago

    Hi Jessica_17,

     

    Currently power bi does not support direct user input into data model values from the report UI. The power bi report canvas is read only so the users cannot type or change data values like SortOrder dynamically for each row. So the user can't enter the value in UI itself for each category.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa

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

Hi Jessica_17,

 

Currently power bi does not support direct user input into fields like sort order from within the report UI. Users cannot manually change column values like sort order directly inside a visual or dataset in a published report.

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

 

Thanks and regards,

Anjan Kumar Chippa

Jessica_17's avatar
Jessica_17
Helper V
1 year ago

HI v-achippa 

Is there any workaorund for it, to make it possible?

  • v-achippa's avatar
    v-achippa
    Community Support
    1 year ago

    Hi Jessica_17,

     

    Yes, we can choose a sort option from a slicer and use DAX to apply sorting dynamically in visuals

    • Create a table with sort options. And then add it as a slicer in the report.
    • Create a measure for example like below to dynamically assign sort values based on the selected sort option:

      DynamicSort =

      SWITCH(

          SELECTEDVALUE('SortOptions'[SortOptionID]),

          1, MAX('YourTable'[SortOrder]),

          2, RANKX(ALL('YourTable'), 'YourTable'[Category],, ASC),

          3, RANKX(ALL('YourTable'), CALCULATE(SUM('YourTable'[Price])),, DESC)

      )

    Use this logic to control sorting in the visuals.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa

    • v-achippa's avatar
      v-achippa
      Community Support
      1 year ago

      Hi Jessica_17,

       

      As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.
      If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

       

      Thanks and regards,

      Anjan Kumar Chippa

      • Jessica_17's avatar
        Jessica_17
        Helper V
        1 year ago

        HI v-achippa 

        Thanks for the solution, but unfortunately it did not worked, user wanted to enter value in UI itself for each category, and the chart should change accordingly.