Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |