Forum Discussion

OskariNi's avatar
OskariNi
Helper I
8 years ago

Create column filled with measures

I have multiple measures (six in total, representing quarters of a year Q1,Q2,etc) that are counts from a column. I would like to create a new column with these six values and add the the column to a...
Need Help
OskariNi's avatar
OskariNi
Helper I
8 years ago

Hi, prateekraina

 

How can I create a bar chart if the X-axis is defined with a column of periods (H1,H2...) and the values are defined with measures.  I can't figure it out. If I just add the measures individually in the Values field the result is this 

prateekraina's avatar
prateekraina
Memorable Member
8 years ago

OskariNi

 

I am sorry but I am not able to undertstand what you actually require.

Columns in the snapshot of excel are something else and what you are showing in chart is different.

 

Please tell you requirement clearly as in What do you want in X Axis and What in Y.

Provide some sample data/screenshots so that we can help you better.

 

Prateek Raina

  • OskariNi's avatar
    OskariNi
    Helper I
    8 years ago

    prateekraina

     

    Lets say I have these percentage values that are in the first bar chart above (0,26% 0,22% 0,25%...) as 7 measures. Then I have a Column that has the corresponding 7 periods

     

     

    So I am asking if I can create a bar chart with these 7 measures (VALUES) and one column (AXIS)?

     

    Can power BI somehow link these measures and column cells (ex 0,26% is the value for period 2015H1). If not can I create a new column that has the 7 measures in 7 cells and use this column as VALUES in the bar chart? 

     

    Oskari