Very straight-forward and a great example - saved my job :) Thanks!
@SolutionsAbroad Жыл бұрын
I appreciate the generosity man, thank you!
@gauravgolecha6821Ай бұрын
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)
@giulianad.r1080 Жыл бұрын
Great video! 🥳 You saved my job! 🤓
@komotour5 ай бұрын
THANK YOU!!!!!
@tingyanruan47442 жыл бұрын
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?
@SolutionsAbroad2 жыл бұрын
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
@ashokkumarpadmanabhan648310 ай бұрын
Excellent Video !!! Can you provide us source files you use in this videos for practice ?
@bernardorainha7213 Жыл бұрын
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?
@rogercortez111 ай бұрын
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?
@abdulazizalshabani66943 жыл бұрын
Thank you for great work How to do that if the date passed its changing the bar color?
@SolutionsAbroad3 жыл бұрын
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!
@CiCi-il6op2 жыл бұрын
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!
@SolutionsAbroad2 жыл бұрын
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: kzfaq.info/get/bejne/l5t4n6Wjp9_Lhnk.html
@CiCi-il6op2 жыл бұрын
@@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!
@AmmarMalik153 жыл бұрын
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.
@SolutionsAbroad3 жыл бұрын
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!
@dddrrr7139 Жыл бұрын
can you do a video for a gantt chart or matrix using the same concept? but three different dates
@zulajenkins6583 жыл бұрын
Thank you. I need only limited periods of data with inactive date. How can I use userelationship eg. > date(2020,1,1)
@dafran5002 жыл бұрын
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.
@cbsound0072 жыл бұрын
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?
@Jir0x Жыл бұрын
same issue here
@RamaKrishnan-qi3rb Жыл бұрын
@@Jir0x any luck?
@RamaKrishnan-qi3rb Жыл бұрын
Any luck?
@ankurbiswas28138 ай бұрын
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 ??
@kimkheangphy67672 жыл бұрын
But the results come out the same as the Total countrows when we put into card.