Need % after selecting value in slicers

[PowerBIBeginer]

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

[Anonymous · Accepted 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.

[PowerBIBeginer]

This is called perfect solution.. Appriciate your reply.. Thanks..

[amitchandak]

@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.

[PowerBIBeginer]

how do i attach screenshot?

[PowerBIBeginer]

Hi All,

Anyone here to help me on this

[PowerBIBeginer]

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.

[PowerBIBeginer]

this is my current dax

% in Market =

var a =

CALCULATE(COUNTA(GCC_Histogram_Data[Market]),

FILTER(GCC_Histogram_Data,GCC_Histogram_Data[Working Market]<>"Admin"),

FILTER(GCC_Histogram_Data,GCC_Histogram_Data[Working Market]<>"Process Support"),

FILTER(GCC_Histogram_Data,GCC_Histogram_Data[Working Market]<>"Quality Control"),FILTER(GCC_Histogram_Data,GCC_Histogram_Data[Working Market]<>""))

var b =

CALCULATE(COUNTA(GCC_Histogram_Data[Market]),

GCC_Histogram_Data[Working Market]<>"Admin",

GCC_Histogram_Data[Working Market]<>"Process Support",

GCC_Histogram_Data[Working Market]<>"Quality Control",GCC_Histogram_Data[Working Market]<>"")

return a/b*100