Forum Discussion
combo chart in powerbi
Source 1: (top)
• Date (not aligned with Source2)
• Count1, Count2, Countn (Also legend for the counts)
Source 2: (bottom)
• Date (non-continuous)
• Symptom Text
• Technician Text
I want to visualize both datasets on the same chart, aligning them based on their respective dates. How can I achieve this effectively in Power BI without overlaying two different charts? I need to display both text data (Symptom Text, Technician Text) and count data (Count1, Count2) on the same time base (Date)/X axis without converting text into numerical values.
Can anyone suggest the best approach or visualization for achieving this?
Hello! In Power BI you should follow the star-schema modeling method where you have fact and dimension tables. When yiu add a date dim table you will join this to each of your fact tables. Then, in a visual you will grab the date elements (year, quarter, week, day) from the date table and then the measures that are utilizing fields from the facts.
http://powerbiwithme.com/2023/07/30/the-star-schema-edition/
http://powerbiwithme.com/2023/08/01/the-custom-date-table-edition/
1 Reply
Hello! In Power BI you should follow the star-schema modeling method where you have fact and dimension tables. When yiu add a date dim table you will join this to each of your fact tables. Then, in a visual you will grab the date elements (year, quarter, week, day) from the date table and then the measures that are utilizing fields from the facts.
http://powerbiwithme.com/2023/07/30/the-star-schema-edition/
http://powerbiwithme.com/2023/08/01/the-custom-date-table-edition/