Forum Discussion
Create column filled with measures
Hi OskariNi,
Here is how you can do it in Power BI:
1. Pull in your columns required for the measure calculation and other columns if you need to showcase them in the table.
2. When the data is loaded in Power BI, right click on your table and Create Measure. Use the same DAX to create your 3 measures which you used in Excel.
3. When all the measures are created, Drag a table visual on the canvas.
4. Drag all the 5 columns which you showcased in the screenshot.
5. Now start dragging your 3 measures, you will see the exact same table as it was in Excel.
Let me know if you face any issues.
Prateek Raina
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
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
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
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