Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

X-Axis to show two data columns like Excel

Hello all, I have just started using PBi. I have a chart in Excel which shows two data values, the month and the population, it looks like this:     The way I acheive this is simply expandin...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi Anonymous , 

    You could try to add two field in chart like below and create month date column by M code , then you could set sort by month date column.

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8krM0zW0VNJR0sizNTS11ASyDPRMzZRidaKV3FKTkOQsoHIWYDnfxCKEnJkxVM4cLOdYgCRnAtNnBNVXiWSmKVTOECznVYrkFjMDqJwxVC4HSQ6mTyk2FgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Month = _t, Population = _t, Rate = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{ {"Population", type text}, {"Rate", type number}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Month date", each "01-"&[Month]),
    #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom",{{"Month date", type date}})
in
    #"Changed Type1"

     Or you also could create a calculated column like below , then set sort by like above image

    Best Regards,
    Zoe Zhi

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

     

dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

I am not clear about your requirement,  did you want to show two columns in the same axis? If so , I think you could try to create a calculated column to combine two column into the same column. If you want to show it in two rows, you could try to use Matrix to achieve this goal. So if possible could you please inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

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

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you for your response. I have replied to the original thread with a more detailed explanation to make it more clear.