Forum Discussion
Sort by Column greyed out with Direct Lake
Hi,
I'm trying to add a custom sort order to a waterfall chart where I would GrossSalesValue followed by Discount/Markdown/ReturnsValue ending with NettValue (as an example) but when using Direct Lake, the Sort by column box seems to be greyed out:
This is how my data model looks, where the dilutioncategorysort table is a simple table with the DilutionCategory and then a number 1 through 8, sequenced in the order I want them to appear:
Anyone any ideas where I'm going wrong?
4 Replies
TheCreepster1 , Use the Property pane on the right side. Know issue. Already notified the team.
Hi amitchandak , thanks for the response. When you say use the property pane on the right side, on the right side of what do you mean? You mention it is a known issue. Is there a log for this somewhere I could use to monitor progress?
amitchandak I've found it now, thanks for your help. I don't know if it works as I'm having other issues visualisation the data, but am hopeful it should be ok.
Hi, I am also having the same issue connecting to OneLake data hub. I am unable to sort by another column as it is greyed out. Did you find a way around this? Thanks
