Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have multiple tables that have tasks and due dates, among many other things. I created a date table and established a relationship with the due date from each table with the overall date table, with a many (due) to one (date table) set up. I would like to make a table (or calendar) that shows the date with items due on that day by task ID, with each Task Type being a seperate a column.
Would be like...
| Due Date | Task Type 1 | Task Type 2 |
| 1/1/23 | ID 1 ID 2 | ID 3 |
Solved! Go to Solution.
This has been solved. It seems, as the video shows, this only works like this with the default visuals. Add visuals seems to disable this ability.
@DCS2011 , the way you displayed Task Type 2, is not possible. It will repeat or have row values
You need to have common dimension to disply things together
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...
Can you explain a little more.
In effect this is what I am trying to do:
This has been solved. It seems, as the video shows, this only works like this with the default visuals. Add visuals seems to disable this ability.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.