Hi Anna -
I certainly would not qualify as one of those smart people but a couple of points
- I would suggest you look at "Pages" as a way to run the same spreadsheets through a viz where only a value in the Category (dimension) change
- Not clear on the percentage format problem - if you have a measure (either a calculated field or data) and you want to change the default format - right click on the measure and in the drop down go to "Default Properties" then follow the path to format and another box will open where you can select the format you want.
- I suspect that you are going to the top ribbon and using Format then format field to do your formatting - and they are changing on you
let me know if this helped
Thank you very much!
I was using the default by right click on the value, then select field and then change the default but that didn't work.
and now it works and the idea of the pages is also a really good idea! thank you you helped me quite well, so in my eyes you are a smart person!
With kind regards,
Glad to help
Good luck with your project