Forum Discussion
Show all items in X axis
Are you using Continuous or Categorical for you X-Axis?
- AlB7 years ago
Community Champion
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 } ] } } } }
- 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.
- Anonymous4 years agoNot applicable
Found this as had similar issue, thanks for posting and its a Yes from me. Turned a head banging into a thumbs up!!
- amyod3 years agoFrequent Visitor
This works...except when you have weeks or months where there is no data. I have no data for September, October, November so my chart skips from month 8 to month 12 which the user might miss unless they look closely. Not help if you're looking for trends at a glance.