Show Data in % in Chart B from Total in Chart A

[Grimoire]

Hi All,

I just had a quick question, since I could not find this particular info while searching. Is it possible to show data as  %  in 1 chart based on the total of another? Both charts are coming from the same Data Table.  

the example below, I would like to show in chart B:

for Week Start, 7 = 34 /841 % = 4 % and so on.  

Thank you for your time and consideration. 

[Anonymous · Accepted solution]

Hi @Grimoire ,
Based on your description, you can customize the display of the datalable
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Create a measure

Measure = FORMAT(SELECTEDVALUE('Table'[Week start])/SELECTEDVALUE('Table'[Released Week]),"0.0%")

Apply the meaure to the datalable value

Final output

If your two tables are separate, you will need to pass the
Released Week and Week start to create a one-to-one relationship between them.

Measure 2 = FORMAT(SELECTEDVALUE('Chart B'[Value])/SELECTEDVALUE('Chart A'[Value]),"0.0%")

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly