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.
Hey there,
I have a visual which shows Percentage of revenue/cost.
It shows this for the entire product range displayed on the left hand side as a table.
When I select a single product on the table I would want the visual to show the revenue / cost for that
specific product e.g. 40%-60%. What it shows at the moment is the revenue/cost compared to the total, so e.g. 0.3% and 0.2%.
Is there any way to change the visual so it shows the total for that exact product?
Thanks in advance!
@Anonymous What's your DAX formula (revenue/cost)?
@Anonymous , not very clear, you should mark it as % in measure/column tools
User | Count |
---|---|
86 | |
82 | |
68 | |
65 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |