Forum Discussion
Chart to plot due dates for different tasks
Hi joker449
Welcome to Power BI 😊 I assure you that you can produce your required output which you created in Tableau using Power BI, too. For example, using standard matrix visual, a visualization like below is created using your data.
What I did is to create a measure of today as the reference line, and create a color measure like below and link it with you measure which you want to color as using conditional formatting.
Today = if(max('Calendar'[Date])=today(),"┃",blank())I created a calendar column and linked with the unpivoted fact table to enable flexible date analysis.
The above example is just using the standard matrix visual, and I suppose you can get exactly the same layout like putting the date at the bottom instead of at the top and thicker reference line for today if you use custom visuals specifically created for your requirement.
I attach the pbix file for the example above.
Best regards,
Hi joker449
Welcome to Power BI 😊 I assure you that you can produce your required output which you created in Tableau using Power BI, too. For example, using standard matrix visual, a visualization like below is created using your data.
What I did is to create a measure of today as the reference line, and create a color measure like below and link it with you measure which you want to color as using conditional formatting.
Today = if(max('Calendar'[Date])=today(),"┃",blank())
I created a calendar column and linked with the unpivoted fact table to enable flexible date analysis.
The above example is just using the standard matrix visual, and I suppose you can get exactly the same layout like putting the date at the bottom instead of at the top and thicker reference line for today if you use custom visuals specifically created for your requirement.
I attach the pbix file for the example above.
Best regards,