Finally! Power BI's New Filtering Feature is a GAME CHANGER!

Поділитися
Вставка
  • Опубліковано 2 гру 2024

КОМЕНТАРІ • 14

  • @catchradioactive
    @catchradioactive 11 днів тому +4

    You are genius 😎

  • @ramukotha
    @ramukotha 6 днів тому +1

    brilliant

  • @ivanzhelyazkov6625
    @ivanzhelyazkov6625 11 днів тому +2

    Nice video! :)
    P.S. Maybe it is better to reference the company table, since you're using its last stage anyway.

    • @MMS-PowerBI
      @MMS-PowerBI  11 днів тому

      Thank you.
      In the company table I don't have a single column containing all the information I want to search for. Only individual columns for various dimensions. That is why I had to create a separate table.

  • @ExcelWithChris
    @ExcelWithChris 11 днів тому +2

    Must admit I have always seen PowerBI as an app for a tablet or iPad. Users using these devices hate typing on them and would prefer normal drop down list to quickly select with a pen or finger. Just my opinion.

    • @MMS-PowerBI
      @MMS-PowerBI  11 днів тому

      I appreciate that, and I do believe as well that the biggest advantage of Power BI is that it can be consumed on the go.
      That's why I believe this option should be used in conjunction with the "regular" slicers. For example, in all of my reports now I have the regular slicer panel and I have added this option as well. And now it's up to the user to choose which option suits best for the situation.
      Let me give you an example: if one of our sales manager would like to use a drop down and filter through 4k customers, then that is a task in itself. On the other hand if they can type the name of the customer, then it is a lot easier. On the same type of scenario, if they want to filter by areas, then it's a lot easier to use the slicer as there are less options to go through.

  • @dafprys7533
    @dafprys7533 6 днів тому

    Good video, have been playing with this too. I'm not sure if I missed a section but how did you get the relstionship from the search_dim to the company_fact to be many to one?

    • @MMS-PowerBI
      @MMS-PowerBI  6 днів тому

      Thank you.
      I believe it was because I was dragging the ID from the dimSearch to the ID from dimCompany. But it makes no difference if you do it the other way. Many-to-One would be the same as One-to-Many if you change the tables order in the relationship.

  • @TemirlanTuibekov
    @TemirlanTuibekov 11 днів тому

    When there will be the update
    We dont have such kind of slicer

    • @MMS-PowerBI
      @MMS-PowerBI  11 днів тому

      I have installed it on 13th of November. If you need to, please download and reinstall the latest version and, in the preview section in the options and settings, enable the text slicer preview.

  • @pragadeeshd2120
    @pragadeeshd2120 8 днів тому

    Sir how to get job using linkedin pls tell some tips

    • @MMS-PowerBI
      @MMS-PowerBI  8 днів тому

      Hello. My last job hunting was a while ago (more than 8 years to be precise) so I won't say that I know 100% what you need to do.
      Having said that, here is what I would do if I would hunt for a job:
      1. I would create myself a portfolio of reports (2-3 reports) on various themes. Maybe one sales, one hr and one financial.
      2. I would find recruiters and/or companies that are active on the BI market and contact them.
      3. Instead of sending them a CV or a cover letter, I would actually send them these report, as they would (in my opinion) have a greater impact. They would showcase my skills better than a CV.
      4. I would not give up :)
      I hope this helps, and again, I would not consider this the absolute truth and the only way to "attack" this situation.