Forum Discussion

jschaefer's avatar
jschaefer
Frequent Visitor
5 years ago

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 Date...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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/