Forum Discussion
Toggle for Columns on a Line and clustered column chart
Hello,
I have the following data sets:
Task Details:
| Task Name | Date | System |
| task 1 | 1/1/2021 | system 1 |
| task 2 | 2/1/2021 | system 2 |
| task 3 | 3/1/2021 | system 1 |
System Dates:
| System | Description | Date |
| System 1 | Test 1 | 1/2/2021 |
| System 1 | Test 2 | 1/3/2021 |
| System 2 | Test 3 | 2/1/2021 |
I am looking for a way to display the count of tasks from Task Details as lines graphed over time and display the Date from the System Dates as a vertical bar for each occurance. I would like to be able to filter on Task Name and toggle the System Dates on and off.
As you can see there is a many to many relationship between system from Task Details and System Dates.
Any thoughts?
1 Reply
- amitchandak
Super User
jschaefer , Create two common tables Date and System, Join them with both tables and used these common tables to analyze data together
For system
A new table, to joined with both table on system
Distinct(union(Distinct(Task[System]),Distinct(System[System])))
Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19
For Date
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.
We need to prefer start schema in power bi
https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/
