Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I implement new feature "Data limit" function to my pbi report which is 202409 version.
It works fine in the power bi desktop, but not working after deploying to PBIRS.
There is a table visual in my page and a column describing ranking.
I set the Data limit to 200 and it only shows 200 records in PBI Desktop.
But when i deploy to PBIRS, the Data limit does not work and the filter pane still shows Data limit to 200.
does anyone have any idea?
Solved! Go to Solution.
Hi @Vanchy_Liao
Thanks for the reply from d_gosbell .
I have a workaround for your reference.
I wrote an Index column in DAX, sorted by Sales from smallest to largest.
Index = RANKX(financials, [ Sales], , ASC, Dense)
Then use that column to filter the table visualization.
Output in PBIRS web portal:
It's also possible not to put the Index column in the visualization, just to filter the effect is the same, I put it in to show the effect more obviously.
I used the Calculated column for the above test and measure for the following.
SUM = SUM(financials[ Sales])
IndexM = RANKX(ALL(financials), [SUM], , ASC, Dense)
Output in PBIRS web portal:
You can also add the index column to the Transform data.
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I confirm the bug, Power BI RS Version1.21.9032.4573(September 2024).
So, September release introduced two new features, and one of them doesn't work.
Hi @Vanchy_Liao
Thanks for the reply from d_gosbell .
I have a workaround for your reference.
I wrote an Index column in DAX, sorted by Sales from smallest to largest.
Index = RANKX(financials, [ Sales], , ASC, Dense)
Then use that column to filter the table visualization.
Output in PBIRS web portal:
It's also possible not to put the Index column in the visualization, just to filter the effect is the same, I put it in to show the effect more obviously.
I used the Calculated column for the above test and measure for the following.
SUM = SUM(financials[ Sales])
IndexM = RANKX(ALL(financials), [SUM], , ASC, Dense)
Output in PBIRS web portal:
You can also add the index column to the Transform data.
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sounds like it might be a bug. I'd suggested raising a support ticket with Microsoft to get this investigated.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
7 | |
4 | |
2 | |
2 | |
1 |