Forum Discussion
Show all items in X axis
Thanks guys. Going for categorical solves the issue but I have quite a lot of charts like that in the file. It'd be quite time-consuming to go chart by chart changing from continuous to categorical. Any idea on how to do that in a faster, more convenient way?
Many thanks
- Nolock7 years ago
Resident Rockstar
Hi AlB and Greg_Deckler,
WARNING: the following doesn't work, but it should be mentioned.
All Microsofts modern file formats are zipped files and folders. I've tried to unzip the pbix file and opened the file Report/Layout which is a JSON file. I changed a property (categorial/continuous) of a chart, zipped everything again and voila an error message that the file is corrupted. Then I tried the same once again only with changing a title of a chart. Also didn't work. It means there is probably a fingerprint somewhere in the binaries.
If it worked you could script it with ease. Unfortunately it doesn't :(
- Nolock7 years ago
Resident Rockstar
Hi AlB and Greg_Deckler,
my next try, maybe you will find a bug in my solution and will be more successful than I was.
My next idea is to use Report Themes - create a new JSON file with a report theme and apply it to every report. According https://docs.microsoft.com/en-us/power-bi/desktop-report-themes it is possible to set all column charts to categorical or continuous (check the JSON file at the end of the MS doc page). I've tried to set many different properties, they worked but setting axisType for categoryAxis didn't.
Do you have any idea why the following JSON theme doesn't work?
{ "name": "My Theme", "visualStyles": { "columnChart": { "*": { "categoryAxis": [ { "axisType": "Categorical", "fontSize": 14 } ] } } } }- Greg_Deckler7 years ago
Community Champion
Nolock - Have you looked at powerbi.tips to generate your theme code? Mike_Carlo might have some insight into this.
- v-danhe-msft7 years ago
Microsoft Employee
Hi AlB ,
I am afraid it may could not support all visuals, you could vote below links for your visuals or could submit an idea:
https://ideas.powerbi.com/forums/265200-power-bi-ideas?query=categorical%20x-axis
If your problem could be solved, don't forget to close this topic.
Regards,
Daniel He
- sergiorodrigues5 years agoFrequent Visitor
Give Nolock the damm trophy.