Forum Discussion

bsheffer's avatar
bsheffer
Continued Contributor
6 years ago
Solved

replace calculated column with measure

I need to re-bin a calculated column ("1-10" combined with "11-20" to becomes "1-20" and so forth but since I'm connected to a published dataset I cannot create a new calculated column, just measures...
Need Help
Tutorial Requests
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi bsheffer ,

     

    'Column series' label can not add a measure, so you need to remodel in the original dataset, and then reconnect this dataset in the new .pbix file.

     

    Best regards,
    Lionel Chen

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

     

parry2k's avatar
parry2k
Super User
6 years ago

bsheffer as you already know that you can only create measures and unfortunately cannot use measure directly for visual  on x-axis etc. Two possible ways:

 

- create bins in the original dataset (preferred)

- create a summarize table with the new bins

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

bsheffer's avatar
bsheffer
Continued Contributor
6 years ago

how would I create a summarized table to do the same job?  Under modelling I only have highlighted new measure and quick measure.  If I can't use the measure in the column series then I can't put the summarized table in the measure.