Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
82 | |
64 | |
62 | |
56 |
User | Count |
---|---|
171 | |
112 | |
110 | |
72 | |
72 |