March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I have a sql table as a datasource for my dashboard. Columns are Sort Order (Integer) and ItemDesc as (Text) (1) 138410 A1_Trenching
Solved! Go to Solution.
Hi @bdoiron,
To sort column "ItemDesc" by column "Sort Order", you need to select column "ItemDesc" first, then click Sort by Column under Modeling tab, and choose "Sort Order".
Regards
Hi @bdoiron,
To sort column "ItemDesc" by column "Sort Order", you need to select column "ItemDesc" first, then click Sort by Column under Modeling tab, and choose "Sort Order".
Regards
Sorry for the delay I was way from the office. Thanks for the reply it worked. However I need a product solution that will enable me to let a customer open our website and enter login credientials to access their dashboard data. From what I have been reading when you publish from this product it must not be sensitive data. Is this a correct assumption?
Hi @bdoiron,
Great to hear the original problem got resolved!
As the new question doesn't relate to your original one, I would suggest you post it in a new thread for better assistance in the forum.
In addition, could you accept the corresponding reply as solution to help others who may also have the similar issue easily find the answer and close this thread?
Regards
Can you set the Sort By field for ItemDesc to SortOrder?
When I am in table view or query sort order is selected for sorting and the data view shows itemdescr in the correct order
A1,A2,.........A10 But when I go back to my visual (report) view it is sorted by itemdescr.
Also i find that if my visual is a bar chart I can click on the .... ellipses on the the upper right and sort order is available but I need the visual in a table format and when I switch and do the same thing sorting is not available. Why shouldnt the query order the data????
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
92 | |
91 | |
79 | |
49 |
User | Count |
---|---|
160 | |
144 | |
103 | |
72 | |
55 |