Forum Discussion
Community ChampionShow all items in X axis
Resident RockstarHi 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 :(
Resident RockstarHi 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_Deckler
Nolock - Have you looked at powerbi.tips to generate your theme code? Mike_Carlo might have some insight into this.
