Forum Discussion
Sorting Blank Values from Fact Table
Hi, Anonymous and thanks for the suggestion. It has pointed me toward the solution that works for me.
The original requirement was to display dimension table entries without corresponding scores in the fact table, in the bottom of the table visual regardless of the sorting order, instead of in the middle as it was before. I've achieved showing them at the end when sorting DESC, in the following way:
- I've added a column in PowerQuery with the sorting order:
- I've sorted the Score group by the new column:
The result is this:
I guess this is the best that can be done at the moment. Report: https://www.dropbox.com/scl/fi/tuaslajaw737hccyhtwzk/Sorting-Blanks-Demo-Report.pbix?rlkey=cfjdy6566bh6w69g1oybn1kgh&dl=0
Thanks all for your help!
Hi, Sahir_Maharaj and thanks for taking the time to provide some suggestions.
Unfortunately, I'm unable to implement them as I do not have a sort column from the dimension table. I'm referring to the standard sorting capability when you click on a heading of a table visual.
I am attaching a sample report - https://www.dropbox.com/scl/fi/rce0wv2bndqo96pddsrsq/Sorting-Blanks-Demo-Report.pbix?rlkey=etzblw6zei00avd15tu47b2ra&dl=0.
The requirement is to show the rows from the dimension table that do not have matches from the fact table but always at the bottom, regardless of the sorting order. At the moment they show in the middle: