Is it possible to change the format of data in the dashboard? i.e., number is coming in and I want to format it to include $ and decimal places. If dates are coming in as December 31, 2017, is there a way to change the format to 12/17 ?
Thanks indvance,
DEL
Hi,
Drop a date on Dashboard and expand the Date.Go to Level one of Date Column and click on the right of Date, it will show the options Filter,Sort,Top or Bottom,Format and Remove column. but you may not find that much of functionality options in dashboard as Active Reports or Reports.
Thanks,
Pratap
Thank you Pratap. I was afraid that was the answer, but wanted to check just in case. :)
Sadly not enough formatting options IMHO !.
It would be great if you could !.
Quote from: DEL2026 on 16 Feb 2018 06:43:13 AM
Thank you Pratap. I was afraid that was the answer, but wanted to check just in case. :)
You can use this as a calculated field for the above format.if your fixed to the above format.here is the expression for 12/17
to_char(cast( [Sales (query)].[Time].[Date] , date),'MM/YY')
Thanks,
Pratap