Forum Discussion

Gaurrav9's avatar
Gaurrav9
Regular Visitor
4 months ago
Solved

Rating migration Power BI view

Hi All, I need to create a rating migration view that displays the change in each individual rating for 2 user selected dates.  Matrix view Row: Current Rating Column: Previous Rating Values...
Need Help
Gaurrav9's avatar
Gaurrav9
Regular Visitor
4 months ago

Hi Ashish,

Thanks a lot for creating this pbix for me.
The version that you have sent works.

 

However, when I try to replicate this logic by using the same table and column names in my Power BI file. I get blanks in the matrix view.

 

Could it be because when I open your pbix file, I get a prompt saying "The queries were authored with a newer version of Power BI desktop and might not work with your version. Please install the latest version to avoid errors when refreshing."
I am using the below version of Power BI:
Version: 2.148.1226.0 64-bit (October 2025)

 

The only difference in my implementation is that I created calculated table for Rating and Rating_dup, whereas you created them in Power Query view. Should that make a difference?

 

Regards,
Gaurav

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 months ago

You are welcome.  FIrst drag to rows, then to values and then to columns.

  • Gaurrav9's avatar
    Gaurrav9
    Regular Visitor
    4 months ago

    Hi Ashish,

    I was able to figure this out. I wasn't drilling down the matrix view from the options provided in the top using arrows.

    Thanks for the help!

    Will this method be able to help me:
    1) Identifying new and dropped entity_id
    2) drill down data to see entity_ids moved from AA to A for example
    3) Number of upgrades and downgrades

    Regards,
    Gaurav


    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      4 months ago

      You are welcome.