Видео

You are welcome. Glad you found it useful.

Hi, thanks for watching the video. I have the measure DAX formula and Logic explanation in details in the video since time slot 4:26 to 6:28. Please have a look closely there. The basic idea of the measure is to identify which KPI the user have selected from KPI slicer for ranking. that is why the two DAX functions switch and RANKXX are adopted in the measure calculation. Regarding the purpose and usage of the function SWITCH and RANKXX, please refer to Microsoft Doc at the microsoft site.

@@MikeYU_BIAnalytics Thank for immidiate reply.... at 2:50 you used another measure [Account Value Rank Index] in IF condition please share script to make this measure...Thanx again

@@MikeYU_BIAnalytics Is it full vedio I think it is just only 6 minutes vedio while you are asking to watch time slot 4:26 to 6:28...

@@YogendraYadav-qp2xj, now I got your point on which my video you have referred to. you can refer to and watch my whole video at the URL link ruclips.net/video/S4hwsHHhuDY/видео.html from the time slot I mentioned before from 4:26 to 6:28, or the specific video at URL link: ruclips.net/video/DdFJCBW8qzE/видео.html&t from time slot 4:15 to 6:20.

Thanks for watching

Hi, I have published three videos in my channel regarding the process which is full automatic process. The video you watched is the part II, the next video part III showed you how to set the refresh schedule in power bi services to run the query and extract the data from OneDrive . The previous video part I shows you on using power automate flow to save email attached data at OneDrive automatically when email arrived to your email box was triggered.

Thanks for the comments. Currently I am and will be offline for a while due to my holidays. I shall check and come back later. Regards Mike

Hi, thanks for the comments. Yes we have. Let me test and come back to you...

Hi, thanks for the comments. I shall check and come back...

@@MikeYU_BIAnalytics Thanks for the content!

Great to hear!

Thanks!

Thank you for your kind reminder. Let me have a research on this first and come back to reach you if needed. Thanks again for your comments!

@@MikeYU_BIAnalytics Thank you

You are welcome

If more than one dot line manager we may need modify the DAX function and enhance the data model. Shall come back after checking..

@@MikeYU_BIAnalyticsThank you for your reply, Please share your mail id (if possible) so that I can share my .pbix dashboard & data for checking

Thanks @@MikeYU_BIAnalytics for replying. Can I share my .pbix & data file with you over mail, if you wish to check.

Hi Ann, can you describe in detail how you want to pivot your columns which all have numbers rather than text? give me example which kind columns you want to keep and which columns you want to unpivot ?

In any case You may try to add row numbers as an index column to the table before unpivoting...in your DAX sub tables always keep the index colum in for creating attribute column and value column..should work...

The Unzip query codes ? You should able to find them in a link I shared in this video descriptions...

Thanks for the comments. I shall find time to look and come back to you.. Regards Mike

Hello LiJun, you may check my suggested solutions for your case in detials from my following blog link : mikeyubianalytics.blogspot.com/2023/07/power-bi-dax-and-visualizations-active.html

@@MikeYU_BIAnalytics Thanks, Mike. I tried to replicate the analysis you did. But I cannot create the dynamic column measure Dynamic Tenure Years. The error message is that "the value for DyanmicTenureDays cannot be determined. ... no current row for this column". Can you figure our what is the issue?

@@lijunchen , Hi Lijun, in your employee table do you have update date/time column which we call it as time stamper for your employee table? which tells when did your guy or system update the whole employee table. usually in HR system the update frequency is once a month . with this time stamper you can have hostroical view to now of your emplyees hire status regrading the change trend of tenure group and age group. if you do not have the time stamper in your employee table. one my suggested workaround is just to create additional column measure in employee table as "UpdateDate =Today()" . then follow my blog to calcaulte tenure days , then tenure years. with this solution you alway get current view (also call a basic dynamic view at today) about your active employee tenure group status and age group(but no histroical info). if you want apply line chart for the workaround solution. you need to place activeEemplyee measure in Y axis and age group or tenure group measure in X axis , Calendar date slicer in the report page should cover today's date. please try this workaround first and let me know your feedback. I shall find time to add the scenario (missing time stamper in employee table) in my blog. regards Mike

@@MikeYU_BIAnalytics Hi Mike. Thanks for your kind reply. I can replicate all your measures. But the final line chart shows only one date value (updatedate as I have only one update date). I have posted the detailed comments in reply to your blog. Please check if you have time.

I am on trip these days and will come back to the question next week...

Hi please watch the user group creations and DAX explainations since 8:15. You may also download the PBIX file from the link I shared in the video descriptions and practice and test the methods via following the video demonstrations...

one way you may try is to change the Visual/column headers/text/background color from dark color to light color, and Visual/column headers/text/text color from light color to dark color

Hi Michael, the DAX unpivot table created by UNION are working for the DQ inputed source data tables and Import source tables both. If you want real time data aling with your original source data to be shown in this DAX created Unpivot table, you need to refresh the PBI file or at PBI services side to (auto) refresh the PBI Dataset if you have published the PBI report, especailly for the imported source data (table}, Have you faced any issue to create the DAX unpivot table based on your DQ "get" source data tables in power BI desktop file? if any issue is possibile to share me your file?

Hi Gert, please watch my next video just after this video. the link is : ruclips.net/video/Ws9UzDE2fNk/видео.html. if the video still not answer your question, please let me know and we may clairfy your needs in moder specific way.

Hi Tracy, I just tested the latest power BI version. The Shift+(left)Click is still working for multiple columns sorting. Not sure what happened on your PC keyboard (and mouse) or your power BI data structure. Assume your PC keyboard working as normal. Pls ensure that your data structure make sense to you for multiple columns sorting. For example, in my video demo data, I have one person has many date measurements, on same day , the person might have different systolic values, same systolic value might have different diasystolic value. Etc.. if you still face the issue you may share me your power Bi data . I shall do a test ...

@@MikeYU_BIAnalytics Hi Mike! Many thanks for taking the time to respond. I believe it's not working because that particular visual is actually not a table, but a matrix. It didn't occur to me at first that they might work differently, but after doing some testing and research, I believe this is the reason it doesn't work. Would you possibly be able to confirm if Shift + Click works for you for matrix visuals? If not that, the only other thing I imagine it could be is an outdated version of Power BI.

Hi Tracy, the shift+ left click sorting by multiple columns method in my video is not working for matrix visual...