Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.