Nice video. What if you wanted to count the number of rows that are after the one date but before the second date? I'm thinking that for each date, you need to calculate the number of dates before the later date, and the number of rows before the earlier date, and subtract one from the other?
Hi there, thanks for watching the video! You might need to use the colour formatter and add a condition on it (in the line chart format pane, with the "fx" sign on it) Hope that helps!
Learn a lot from your channel. I was also wondering what if I got dates from different tables and I would like put them in the matrix how can I achieve it?
Hello. Thank you for this video. It was very helpful in resolving a similar issue. One question I have is that, for example, let's say you also have a "business Unit" visual and you click on a specific bar on that business unit, the trend visual shows the active line, but it disabled the inactive line. If I deselect a business unit, then I can see both lines on the trend line. Any ideas how to address that issue?
good video, how would you do if you wanted to see a bar chart in which you wanted to have the number of active workers per month? In other words I had to work simultaneously with my start date and end date. How would i be able to do that by filtering by month and seeing the filtered month and the previous 11 months?
Great video, perfectly resolved my current issue for a multi date chart - one more question, I am trying to add a tooltip page based on the date with no relationship with Date table, say " list the names of leavers when I hover on the chart? How can I do that? Thank you!
Hiya, if it's not available in the Format Pane, then you'll need to be slightly creative with it. You can either create an invisible button, or other tricks like here: ruclips.net/video/a5HlBrBygVE/видео.html
@@SolutionsAbroadNo issue in adding a tooltip, but I struggle with the tooltip report itself that lists all the names of leavers in the example in your video? What DAX can list the leavers names, as it is not a calculation. Thank you!
How to create MTTR ? I have incident opened day ID and resolved day ID in one table and Date in another table. I think it need to reference opened/ resolved day ID with Date table date but how to pull this ? can help ??
Hi, thank you for this video. I have multiple charts with different data from 2 dates and using slicer. The data in charts are coming fine but when I apply slicer date, the data is wrong because of the multiple date relationships. Any suggestions here?
One question how can you make this link with a table, for example you have a line chart and a table and you want to click on a certain day on the line chart and see more info on the table. Because when I have tried it, it showed nothing on the table. Great video btw.
Hey Ammar, thanks for watching! Your line chart and table needs to have the same columns for it to work, As long as you're using the same columns from both your line chart and your table, this should work. If you're using two different tables, one for your table and one for your line chart, make sure you create a relationship so Power BI knows how your data is related. Hope that helps!
Thanks for this video. However it is not working for me. Doing the exact same steps but when I use the date from the date table, the line chart goes blank.
![Handling Multiple Dates in Power BI With DAX [2022 Update]](/img/1.gif)
Very straight-forward and a great example - saved my job :) Thanks!
I appreciate the generosity man, thank you!
Is there a way to use the same slicer from calendar table to slice two different tables (table 1 using start date ; table 2 using end date)
Nice video. What if you wanted to count the number of rows that are after the one date but before the second date? I'm thinking that for each date, you need to calculate the number of dates before the later date, and the number of rows before the earlier date, and subtract one from the other?
You saved my night!
Glad it helped, thanks for watching!
It worked! Nicely explained here 👏
Thanks Fernand! Very Helpful!
Thank you for great work
How to do that if the date passed its changing the bar color?
Hi there, thanks for watching the video! You might need to use the colour formatter and add a condition on it (in the line chart format pane, with the "fx" sign on it) Hope that helps!
Learn a lot from your channel. I was also wondering what if I got dates from different tables and I would like put them in the matrix how can I achieve it?
Hi there, if you want to use dates from different tables, you'll need to create a relationship from them to your central calendar table
Great video! 🥳 You saved my job! 🤓
Hello. Thank you for this video. It was very helpful in resolving a similar issue. One question I have is that, for example, let's say you also have a "business Unit" visual and you click on a specific bar on that business unit, the trend visual shows the active line, but it disabled the inactive line. If I deselect a business unit, then I can see both lines on the trend line. Any ideas how to address that issue?
Excellent Video !!! Can you provide us source files you use in this videos for practice ?
good video, how would you do if you wanted to see a bar chart in which you wanted to have the number of active workers per month?
In other words I had to work simultaneously with my start date and end date.
How would i be able to do that by filtering by month and seeing the filtered month and the previous 11 months?
Great video, perfectly resolved my current issue for a multi date chart - one more question, I am trying to add a tooltip page based on the date with no relationship with Date table, say " list the names of leavers when I hover on the chart? How can I do that? Thank you!
Hiya, if it's not available in the Format Pane, then you'll need to be slightly creative with it. You can either create an invisible button, or other tricks like here: ruclips.net/video/a5HlBrBygVE/видео.html
@@SolutionsAbroadNo issue in adding a tooltip, but I struggle with the tooltip report itself that lists all the names of leavers in the example in your video? What DAX can list the leavers names, as it is not a calculation. Thank you!
It helps me and it will help others.
How to create MTTR ? I have incident opened day ID and resolved day ID in one table and Date in another table. I think it need to reference opened/ resolved day ID with Date table date but how to pull this ? can help ??
THANK YOU!!!!!
Hi, thank you for this video. I have multiple charts with different data from 2 dates and using slicer. The data in charts are coming fine but when I apply slicer date, the data is wrong because of the multiple date relationships. Any suggestions here?
same issue here
@@Jir0x any luck?
Any luck?
Thank you. I need only limited periods of data with inactive date. How can I use userelationship eg. > date(2020,1,1)
One question how can you make this link with a table, for example you have a line chart and a table and you want to click on a certain day on the line chart and see more info on the table. Because when I have tried it, it showed nothing on the table. Great video btw.
Hey Ammar, thanks for watching! Your line chart and table needs to have the same columns for it to work,
As long as you're using the same columns from both your line chart and your table, this should work.
If you're using two different tables, one for your table and one for your line chart, make sure you create a relationship so Power BI knows how your data is related.
Hope that helps!
Thanks for this video. However it is not working for me. Doing the exact same steps but when I use the date from the date table, the line chart goes blank.
Can i have file to Practice?
can you do a video for a gantt chart or matrix using the same concept? but three different dates
But the results come out the same as the Total countrows when we put into card.