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.
Hi,
Is there any workaround for sorting in Play Axis (Dynamic Slicer) viusal.
I have a dataset of around 1 lakh rows where i have Timestamp column and an imageURL.
I want my users to see those images in Descending order fashion (Latest -> Earliest).
The intention is to create an Image slider kind of look and feel so i chose this visual. However, it always starts from Earliest record to Latest which defeats my purpose.
Kindly suggest any workarounds.
Edit 1: My dataset is connected live to Power BI Service so i cannot use Query Editor and "Sort by Column" feature.
Prateek Raina
Solved! Go to Solution.
The visual has been updated by the developer with this functionality. Refer this issue here
The visual has been updated by the developer with this functionality. Refer this issue here
Hi Prateek,
There is a workaround.
1. Sort the column by the order you want in the Query Editor.
2. Add an index column. Then Apply&close.
3. In the data view, select the column, click the function "Sort by column" in the ribbon, make the column sorted by the index.
You can try it in this file.
Best Regards,
Dale
Hi @v-jiascu-msft,
Thank you for this solution. It is indeed a workaround to achieve this.
However, datasets which are connected live (Ex: Power BI Service) are barred to use Query Editor and even "Sort By Column" in the ribbon.
Unfortunately my report is connected to one of such data sets. Anyway, Thanks for this. It surely will come handy in future 🙂
Prateek Raina
Hi @prateekraina,
There is still a workaround. Maybe a few more steps needed. Set the "Sort By Column" in the original dataset. I have tested it successfully. Please give it a try.
BTW, Play Axis is supplied by the third party rather than MS. If you need more help (or features) about this visual, maybe you can go to here.
Best Regards,
Dale
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 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |