Hello Power BI Guru's,
I am not a programmer & also new to Power BI.
I seek a solution to my report with "Matrix" visualisation.
The table below with blue color text (2nd row) is my table header. Rest rows are fictitious values I built to seek help from you' ll.
Q - I am looking for a Customised Ranking Solution -
a) First of all, I can assign a predefined rank to values like "Multiple Customers" and any other few more values (say Bankrupt companies) that I find in field "Customer".
That predefined values (Customer Rank) can be 51, 101, 301, etc., in short, I should be able to define that and it is applicable to entire table wherever such identified value appears.
b) & the rest cases are Ranked based on field "Financial year" with highest value by sum of field "Values USD" in that financial year.
See the field "Expected Result" for what I expect as an answer.
The idea is that such names like "Multiple Customers" or any Bankrupt Companies dont appear in my Top 300 (or say Top 100 or 500) customers in "Matrix Visualisation".
I have no problem if that same "Custom Rank" number I defined, is also shared with any other customer assigned by the formula/(s).
Thank,
Chandan.
| Text field | Text field | Text field | Text field | numeric field | | |
| Customer | Product | Month | Financial Year | Values USD | Expected Result | Condition |
| Microsoft | Mobile | July' 2015 | 2015-16 | 4,000 | 1 | <- as per formula based on field "Financial Year" & Sum of field "Values USD" |
| FaceBook | Mobile | Aug' 2015 | 2015-16 | 3,000 | 2 | <- as per formula based on field "Financial Year" & Sum of field "Values USD" |
| Apple | Mobile | July' 2015 | 2015-16 | 2,000 | 3 | <- as per formula based on field "Financial Year" & Sum of field "Values USD" |
| General Motors | Mobile | July' 2015 | 2015-16 | 1,000 | 4 | <- as per formula based on field "Financial Year" & Sum of field "Values USD" |
| Multiple Customers | Mobile | Aug' 2015 | 2015-16 | 5,000 | 301 | <- conditioned to assign Rank no 301 or any such custom Rank number defined by me |
| Cargill | Mobile | July' 2015 | 2015-16 | 100 | | <- as per formula based on field "Financial Year" & Sum of field "Values USD" |
| Walmart | Mobile | July' 2015 | 2015-16 | 50 | | <- as per formula based on field "Financial Year" & Sum of field "Values USD" |
| Microsoft | Mobile | June' 2016 | 2016-17 | 4,130 | 2 | <- as per formula based on field "Financial Year" & Sum of field "Values USD" |
| FaceBook | Mobile | May' 2016 | 2016-17 | 6,098 | 1 | <- as per formula based on field "Financial Year" & Sum of field "Values USD" |
| Apple | Mobile | Mar' 2017 | 2016-17 | 2,065 | 3 | <- as per formula based on field "Financial Year" & Sum of field "Values USD" |
| General Motors | Mobile | April' 2016 | 2016-17 | 1,033 | 4 | <- as per formula based on field "Financial Year" & Sum of field "Values USD" |
| Multiple Customers | Mobile | September' 2017 | 2016-17 | 5,163 | 301 | <- conditioned to assign Rank no 301 or any such custom Rank number defined by me |
| Cargill | Mobile | October' 2016 | 2016-17 | 103 | | <- as per formula based on field "Financial Year" & Sum of field "Values USD" |
| Walmart | Mobile | September' 2016 | 2016-17 | 52 | | <- as per formula based on field "Financial Year" & Sum of field "Values USD" |
