topic Re: Slicer to Parameter Issue in Report Server

Slicer to Parameter Issue

i820017 — Thu, 05 Aug 2021 14:52:31 GMT

Hey Everybody,

I am converting a Power BI report to a paginated Report.

Anyway, here is a screen shot of the 'Date Complete' slicer on the Power BI report. It is in descending order of dates.

Here is a screen shot of the same slicer or parameter in the paginated report.

As you can see, the paginated report has 'Completed Date' in ascending order of dates. Does anyone know how to put the 'Completed Date' parameter in descending order of dates (like what is shown in the 'Date Complete' slicer in the Power BI report)?

Thanks

Dan

Re: Slicer to Parameter Issue

sevenhills — Thu, 05 Aug 2021 21:08:26 GMT

If it is a sql data source, you can use

order by <col> desc

Note: Paginated reports / ssrs reports display the way they get the data outputted from the source. We need to explicitly specify the order.

Re: Slicer to Parameter Issue

i820017 — Fri, 06 Aug 2021 14:01:42 GMT

It is not a sql data source as seen below.

The Power BI report explicitly shows the order of the slicer to be in descending order of dates. However, when this Power BI report is converted to a paginated report, then the paginated report automatically puts the parameter in ascending order of dates.

Re: Slicer to Parameter Issue

sevenhills — Fri, 06 Aug 2021 21:14:40 GMT

I dont see completed date in your screenshot. It is ok. I saw you are using DAX, then try using ORDER BY [Date column] DESC.

check the link for syntax:

https://docs.microsoft.com/en-us/dax/summarizecolumns-function-dax

Paginated reports are SSRS reports tuned for Power BI servers. so, it is old school. You need write explicitly.