Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Sorry, the question was not clear, I want to sort using the property colum, I have two datasets the first is in the main visual table (main page) and I have many columns, but for this case I just got two. I have two pages for the Main page(Table1) and the drillthrough page.
Table1
Name Service product
Jhon Buy 4
Alice Sell 3
I have unpivoted using service and property column and It look like this
Name Attribute Values
Jhon Service Buy
Jhon Product 4
Alice Service Sell
Alice Product 3
What I wanted to do is, when i drillthrough on table1 (Table Visual on main page) using Jhon(Table1), I wanted to see something like this with the sort order by attribute just like below
Name Attribute Values
Jhon Service Buy
Jhon Product 4
But I see something like this
Name Attribute Values
Jhon Product 4
Jhon Service Buy
the Attribute column Order is random when i drillthrough
Any ideas?
Solved! Go to Solution.
Hi @Yonas ,
Maybe you could try adding an index column and then sorting by it.
@Yonas ,Can you share sample data and sample output.
@amitchandakBecause of privacy I can not share sample data from my case, Can you rather use the above example datasets?
Hi @Yonas ,
Maybe you could try adding an index column and then sorting by it.
Wait, what are you sorting on in the visual?
Honestly, it's an interesting question of whether/how sort is preserved as you drill through.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
66 | |
62 | |
62 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |