Forum Discussion

perweenshaz90's avatar
perweenshaz90
New Member
1 year ago

Power query

I have created a column in query editor by multiplying quantity into price just to get the sales amount but this is not appearing in report section in clustered bar chart 

Need Help

4 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    1 year ago

    Hi perweenshaz90 - I hope in Power Query Editor, after you creating the column (add column), did you click Close & Apply to load the changes back to the data model? If not, go to Home > Close & Apply in Power Query Editor to apply the changes.In the Report View, locate the table where you added the column in the Fields pane.

    or 

     

    you can also create a new measure in power bi desktop using dax function in table view. 

     

    Hope the above details helps.

     

  • saud968's avatar
    saud968
    Memorable Member
    1 year ago

    Below are few options that might help you out

    Check Data Model: Ensure that the new column is part of the data model you're using for the report. Sometimes, new columns need to be refreshed or reloaded into the report.

    Field List: Verify that the new column is available in the field list of your report. If it's not, you might need to refresh the data connection.

    Chart Configuration: Make sure you've added the new column to the appropriate axis or value field in your clustered bar chart. Sometimes, it might not be automatically included.

    Data Type: Ensure that the new column's data type is appropriate for the chart. For example, if it's a numeric value, it should be recognized as such.

    Filters: Check if there are any filters applied to your report that might be excluding the new column's data


    Best Regards
    Saud Ansari
    If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!


  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    Super User
    1 year ago

    Hi perweenshaz90 

    Ensure that the table containing the new column is loaded into the report. You can check this in the "Fields" pane of the Power BI report view or Table view.

    Sometimes, the column might be hidden in the "Fields" pane. Right-click the table in the "Fields" pane and select Show Hidden to check if the column is marked as hidden.

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi,

    Thanks for the solution Bibiano_Geraldo , saud968  and rajendraongole1  offered, and i want to offer some more information for user to refer to.

    hello perweenshaz90 ,

    1. Make sure there is no error in the new column

    2.After creating the column, plese refresh the report in desktop by clicking 'refresh' button.

    3.You can remove the chart abd recreate a again.

     

    Best Regards!

    Yolo Zhu

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