Slicer to Parameter Issue

[i820017]

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

[sevenhills]

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. 

[i820017]

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.

[sevenhills · Accepted solution]

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.