Forum Discussion
Split Time Series Chart by Dimension?
My company is making a transition from Tableau to Power BI and I'm the lucky person tasked with moving existing reports to Power BI.
We use a lot of time series charts and one of the key features of Tableau is the ability to take a time series chart (any chart/graph really) and easily split that by different dimensions. For example, say there is a chart that represents total transactions for all regions combined. I can easily drag a dimension (in this example country) to that chart and split that chart into separate charts based on the country name. Please see the below Tableau screenshot:
My question is, does a visualization exist in Power BI that will allow me to do something similar? From what I can tell, I'd have to make a separate bar chart for each individual country.
Any thoughts or suggestions are greatly appreciated.
3 Replies
I found the closest solution is to use the Line Chart by Akvelon visual and put the dimension I want to split the graph by into the "Row By" bin. It can't display bars but it's the closest thing I've found. There is a bar chart made by Akvelon that splits the dimension, however, it didn't have the ability to color each "Row By" split a different color.
csududeI am currently doing this too. This is what can be replicated in PBI
https://community.powerbi.com/t5/Desktop/Comparing-Tableau-Viz-to-PBI-Viz/m-p/732970#M353557
Hi! did you find an answer to your question?
I got the same challenge.
Best regards, Olga
