Forum Discussion

kelvin-lkhca's avatar
kelvin-lkhca
Icon for Helper I rankHelper I
2 years ago
Solved

PNL by Account

Hi All,   I have created a measure and wish to achieve the something like illustrated below with the measure and matrix table,         However, I can't get the same result as above table ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

access denied.  Where in your raw data do you indicate the expected sort order of your categories?

kelvin-lkhca's avatar
kelvin-lkhca
Icon for Helper I rankHelper I
2 years ago

Hi lbendlin ,

Sorry that forgot to change the access restriction previously. Please find below for the link.

 

Yes, there is one table in the PBI, shown as below, is used to sort the order of the categories.

 

 

 

 

Folder link

https://drive.google.com/drive/folders/1XTp2ajb8ZnncG1YqdgvMIxfXfedQKdIe?usp=sharing

 

Sample Data link

https://docs.google.com/spreadsheets/d/1s8CZ_6VxIsI69qJP5yxow17i1t4MlCgb/edit?usp=sharing&ouid=110570727743616034194&rtpof=true&sd=true

 

PBI Link

https://drive.google.com/file/d/1M6_Ue3A0aCJ_1yR4vXijeXfVAktt-Gri/view?usp=sharing