Forum Discussion
Create a timeline view using the Stacked Bar Chart Visualiztion
Have you tried:
make the axis values convert from the numeric format into date format:
On the right you have the list with data fields, select the field which contains your date (now showing as a number). Then click on the ribbon on modeling tab, and for Data type select Date/time:
set it so these are monthly values, not every 50 days
Have you tried adding a slicer? It is unfortunate that you are not allowed to use a custom visual, as the Timeline slicer in the marketplace is really what you'd need here. However the built in Slicer can at least help you. You could eventually try to add a new column which calculates the month, and then apply the slicer on that column.
Hope this helps!
Thank you for your outreach on this matter. I attempted your solution on the Modelling tab, but unless I am missing some other step, that just blows up the visual and I get the "Something is wrong with one or more of the fields" message.
I will see what I might be able to do with a slicer or displaying some sort of rolling series of months.
I guess the bar chart doesn't work with dates on the value axis, tried this myself and couldn't get it to work either.
Just thinking out of the box: what you're building looks a lot like a project / activity chart, which normally could be displayed with a gantt chart. You mention that 3rd party visuals are forbidden, however Microsoft offers a custom visual in the marketplace (https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380765?tab=Overview). Strictly speaking this isn't 3rd party, as it is from Microsoft as well :) .
I appreciate that there is a section of "Microsoft Endorsed" items in the marketplace much like way back in the day MS placed their Powerpoint "Clip Art" out on their website that may be its purpose. As you may have ben able to tell from my email address, I work in a bank's IT Security dept and the Risk Adverse orientation is as high as you can imagine for good reason. It took approvals just to get access to this site. The position would be if Microsoft is certain there is no risk of malware or backdoors with the visual, then include it in the standard package of visualizations we get when we download. Other visualization types have been added over time so we know this could be done. Perhaps that could be added to the no doubt lengthy suggestionb list for this product?
Note that in the meantime, my Senior Leadership understands and accepts the current situation so its not like I'm under pressure to quickly find a resolution to this.
I continue to thank all of you for your suggestions and feedback!