Forum Discussion
Merging multiple TotalYTD visualizations.
- Anonymous1 year ago
Thanks for the reply from amitchandak , please allow me to provide another insight:
Hi cjsund ,I created four tables and four corresponding measure:
Here are the steps you can follow:
If you want to display the values of all four line charts on the same axis, you can simply create a table of dates to be used as a bridge table with the dates of the other four tables in a join relationship.
Using the Line chart, use the [Date] of the date table for the X-axis, and place the four measures in the Y-axis.
If you want to display different four line charts in the same visual, you can try to create a Group_Table and place it in Small multiples using [Group] as a category.
Enter data – create a table.
Create measure.
Measure = SWITCH( TRUE(), MAX('Group_Table'[Group])= "Measure1",[Measure1] MAX('Group_Table'[Group])= "Measure2",[Measure2], MAX('Group_Table'[Group])= "Measure3",[Measure3], MAX('Group_Table'[Group])= "Measure4",[Measure4] )Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
cjsund , With help from date table, create a measure like below. And use status as a legend on the visual. Having a separate date/calendar table is important. Join date of Date table with the date of your table and use columns from date table in measure, visual and slcier
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.