Thin Reports - Sorting and Measure Scaling/Formatting?

[thx1137]

Greetings all,

Working on deploying some thin reports (using a shared, centralized data set and both table and matrix visuals) and noticing that I can't edit the Sort by Column in the Column Tools menu nor can I change the scaling/format of the values in the matrix (e.g. show the values in thousands) as those options are grayed out.  Is this by design?  I'm hoping I'm doing something wrong as most other tools handle this easily.

[thx1137]

Many thanks...I dug into this a bit more and came to the same conclusion which is unfortunate (as again, this is not a problem in other tools).  I believe the same is true for sorting.  The workaround there is to set the default sorting in the data set...but if the user wants to sort differently than that, I do not believe that they can.

[Anand24]

@thx1137 ,
When you connect live, you can still create a sorting table in your report and create a relationship with existing live model's table. Use this sorting table as dimensional table and pull that into visualizations.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Anand24]

Hi @thx1137 ,
Can you attach a screenshot here of the field and these options bein greyed out?

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[thx1137]

Here's an example.  I've clicked on Sales Amount and under Column Tools, my options for formatting (scaling, etc.) are grayed out.

[Anand24]

@thx1137 ,
When you connect live to any published dataset, you can't make any changes to the existing field properties. Hence, it is greyed out.
You can do 2 things here:
1. Change format in the published dataset - This will change its formatting in all connected reports as well

2. Create a new calculated measure, format it the way you want and then use this new measure. In your case, this measure would be as simple as Sales = SUM('Sales'[Sales Amount])

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Brunner_BI]

If you create a measure on top of this column in the thin file you will be able to change the formatting.