How to use USERELATIONSHIP to handle MULTIPLE DATES in Power BI / DAX Basics 2021

Рет қаралды 41,497

Fernan

Күн бұрын

Пікірлер: 30

@yourcfoguy Ай бұрын

It worked! Nicely explained here 👏

@datalab365 5 ай бұрын

It helps me and it will help others.

@gmartinezm Жыл бұрын

You saved my night!

@SolutionsAbroad Жыл бұрын

Glad it helped, thanks for watching!

@deejohn064 Жыл бұрын

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! 🤓

@komotour 5 ай бұрын

THANK YOU!!!!!

@tingyanruan4744 2 жыл бұрын

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?

@SolutionsAbroad 2 жыл бұрын

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

@ashokkumarpadmanabhan6483 10 ай бұрын

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?

@rogercortez1 11 ай бұрын

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?

@abdulazizalshabani6694 3 жыл бұрын

Thank you for great work How to do that if the date passed its changing the bar color?

@SolutionsAbroad 3 жыл бұрын

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-il6op 2 жыл бұрын

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!

@SolutionsAbroad 2 жыл бұрын

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-il6op 2 жыл бұрын

@@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!

@AmmarMalik15 3 жыл бұрын

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.

@SolutionsAbroad 3 жыл бұрын

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

@zulajenkins658 3 жыл бұрын

Thank you. I need only limited periods of data with inactive date. How can I use userelationship eg. > date(2020,1,1)

@dafran500 2 жыл бұрын

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.

@cbsound007 2 жыл бұрын

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?

@ankurbiswas2813 8 ай бұрын

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 ??