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, 

 

Thank's for the reply. The thing is that I don't really want to see the table on the canvas. I wan't to have the table as data in the FIELDS part and then use it to draw a bar chart like this: 

 

Thanks, Oskari

prateekraina's avatar
prateekraina
Memorable Member
8 years ago

Hi OskariNi,

 

Well, that will simply increase the data size of the report. 

You can create the bar chart without having to do so.

 

Still, if you want to do that only, then you need to create Calculated Columns instead of measure to achieve that. However, i doubt that you present DAX formula may not work as is, you will have to change it to get same results as measure.

 

If you want to go with ideal scenario, you must use measures.

 

Prateek Raina

  • 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