When connecting to a cube how can I change the value to a percentage on a column chart?

[bluna]

When connecting to a cube how do a change a value to a percent on a column chart?  It's available on a pie chart via "Detail Labels" but disappears when change the visualization to a column chart?

[katika555]

@bluna Its not depend on you are connected to Cube or not, 

Steps:

1. on Fields Pannel Change : Show Value as ->Percent of Grand Total

2. On Format Tab Data Lables ON 

[bluna]

I don't see that option. "Show value as...", and Data Labels is "On".  Is there something else that I need to do to enable that option "Show value as..."?

[katika555]

@bluna What is Amount Data Type? Decimal number?

[bluna]

  It's "General", but I'm not able to change it. 

[katika555]

@bluna 
On your screen its Measure not column :)))
What you can do in this situation:
1. Create Measure (As you can add only Report level measure in PowerBI with live cnnection from Cube)
2. Your New Measure Value Must Be 

New Measure = Divide([Amount],Calculate([Amount],all()),0)

3. Change Format for Percentage
4. use your new measure 🙂

[bluna]

How do I enable the ability to create a measure?  Everything is greyed out :(. I don't see a way to create a measure 😞

[katika555]

Right Click on any table -> New Measure

[bluna]

I don't have that option when right-clicking in any table.  The only selections are "Collapse All" or "Expand All".

[katika555]

Request permissions from admins : Browser, Content Manager, Report Builder

[Anonymous]

Hi  @bluna ,

In Visualizations - Format -Data labels - set this to ON.

Click on Visualizations – add data to your visual.

Result：

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bluna]

For a standard connection I see this option, but when connected to a cube via SQL Server Analysis I don't see the option to select the "Show value as" option.

- Data labels is On 

- When clicking on Y-axis, the options are: "Remove Field", "Rename for this visual" & "Move to".

[bluna]

Following up on my request, when connected to a cube via SQL Server Analysis, Live connection, I don't see the option to select the "Show value as" option.

- Data labels is On 

- When clicking on Y-axis, the options are: "Remove Field", "Rename for this visual" & "Move to".  There is no "Percent of Grand Total" selection.

[Anonymous]

Hi  @bluna ,

Each Visual has its own role and usage, and the location of certain functions is also different.

For column chart Visual, you can click on the column's yellow flag - Show value as == Percent of grand total.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bluna]

I don't see the options you shared when connecting to a Cube.  This is what I see under the Y-axis, for a column chart.