Clustered column chart

[Anonymous]

Hello, 

I am beginning on Pocwer BI and I am trying to create a column chart to display the number of times a country is mentioned (in percentage). I have a table like so :

Country	Date
France	X
Luxembourg	x
Ireland	x
France	x
France	x

I have categorized the data for "country" as Country.

And I have a measure like such : 

Measure 2 = CALCULATE(COUNT('test country'[country]))

When I use this measure for my column chart (with the data from the colum country of my table), it only shows a count. So I changed the value part of the histogram (in which I put my measure) to show the % of the grand total. The problem is it shows the percentages but with decimals. Is there a way to only have the rounded percentage ? 

Thank you for your help !! 🙂 

[v-cazheng-msft · Accepted solution]

Hi @Anonymous,

Please create a new Measure to calculate the percent for you, then change its Format to Percentage and the number of decimal places to 0.

Country% =
VAR totalCountry =
    COUNTROWS ( ALL ( 'test country' ) )
VAR countCountry =
    COUNT ( 'test country'[Country] )
RETURN
    countCountry / totalCountry

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun

[speedramps]

Hi MarieAlex

To format a percentage then click on the measure in the field well, then click on format, percentage and specify the number of decimals.

Please raise another ticket for the other problem with an example of input data (as table not screen print so we can import is and build a solution. And an example of the desired output with a clearer description. Thanks. We wnat to help but first we really need to undertstand what you want.

I have helped you, now please help me by giving kudos.

Click the thumbs up and accept as solution button. 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each solver will get the kudos they deserve. Thank you !