Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm very new in power bi learning. I've one slicer, one stacked column chart and one card.
slicer = market items, one stacked column chart = working market items, card = one measure written..
*items mean data
What I'm looking is when I will click on item in slicer, I should get % in card.
after selecting any item from slicers, to get % calcaution below is the logic-
var a = highest value in column chart
var b = total of all the numbers which is availble in chart
currently I've this dax with me. But this only give me % after selecting (clicking) on bar. Instaed of this, when I will select value in slicers, it directly show me in card.
Pls guide me on this
Solved! Go to Solution.
Hi @PowerBIBeginer ,
You may try to click this percent sign in the Measure tool. The value will then be returned as a percentage.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @PowerBIBeginer ,
You may try to click this percent sign in the Measure tool. The value will then be returned as a percentage.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is called perfect solution.. Appriciate your reply.. Thanks..
@PowerBIBeginer ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format?
Appreciate your Kudos.
how do i attach screenshot?
Hi All,
Anyone here to help me on this
let me explain one more time..
I have one slicer - it contains market value
I have one stacked column chart - it contains working market value (i.e. graph)
the dax which I've just shared, it shows me % after clicking on every column bar
instaed of this, when I'll click (select) value in sliecer (i.e. market item which is also available in working market graph) will directly show me % of total.
this is my current dax
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |