Видео

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

I shall try , thanks for following up.

@@MikeYU_BIAnalytics yes please.thanks

Hi, Have you done two setup actions at services after you publishing your report there. the two steps in details have been descripted in video starts from 9:24 till 10:04. they are : 1) at dataset level to add your user email address into RLS user group via dataset "security" option, do not forget to press "add" button. 2). at workspace level to add your user as "viewer" via "access" option with the user email address, do not forget to press "add" button. at the step 2) your users can not be other role but "viewer" only in the workspce !!! if you still face issue after the two steps please drop me the screen print of your error.