Hi guys, this might be a longshot and not appropriate (in which case my apologies and please remove it), but I genuinely want to use my Excel datasets in Power BI but I want to make a specific type of visualisation that I am not aware of and it might have to be some sort of converted type - I think I really need to chat to someone on a Power BI forum (or if anyone here is a Excel Pivot Tables/data nerd/Power BI expert shout out!)
I am aware there is an 'official' Microsoft forum for Power BI, but I wondered if anyone knew of another 'independent' reputable one, similar to this forum, where I can chat and get advice about all things Power BI?
TIA, sorry if it's not appropriate to post this here - a bit desperate as on a deadline.
FP
Power BI
-
- StarLounger
- Posts: 58
- Joined: 10 Mar 2021, 22:57
Re: Power BI
I'm not sure how to qualify your post. Do you want a solution or do you just want to "talk about the weather"?
-
- 2StarLounger
- Posts: 130
- Joined: 12 Aug 2020, 08:40
-
- StarLounger
- Posts: 58
- Joined: 10 Mar 2021, 22:57
Re: Power BI
so ask a specific question and preferably attach a file and add a detailed description of the problem
-
- 2StarLounger
- Posts: 130
- Joined: 12 Aug 2020, 08:40
Re: Power BI
Ok. here is a pic (attached). How can I organise these number ranges into numerical order on my visualisations?
Last edited by FrecklePaw on 19 Jun 2023, 21:52, edited 1 time in total.
-
- StarLounger
- Posts: 58
- Joined: 10 Mar 2021, 22:57
Re: Power BI
I should say : attach pbix file, pic is useless in most cases
-
- 2StarLounger
- Posts: 130
- Joined: 12 Aug 2020, 08:40
Re: Power BI
Ah, sorry about that. In the meantime, if I can describe it: it's a very basic pic - shows a simple horizontal bar chart the and y axis has the number ranges in random order thus:
250-499
500-999
1000-4999
5000-19999
>=20000
<250
How can I organise them so that the <250 is at the top, and then in sequential numerical order? Like this:
<250
250-499
500-999
1000-4999
5000-19999
>=20000
-
- StarLounger
- Posts: 58
- Joined: 10 Mar 2021, 22:57
Re: Power BI
at first glance use Pivot Table with defined grouping , you don't need PowerBI to do that
-
- 2StarLounger
- Posts: 130
- Joined: 12 Aug 2020, 08:40
-
- StarLounger
- Posts: 58
- Joined: 10 Mar 2021, 22:57
Re: Power BI
what part of this post did you not understand?
however PBI contain Pivot and Power Query,
-
- 5StarLounger
- Posts: 818
- Joined: 24 Jan 2010, 15:56
Re: Power BI
How have you done the grouping? I often use a separate 2 column table with the banding names in one column and the order (numeric) in the second, then set the second column as the sort by column for the table.
Regards,
Rory
Rory
-
- 2StarLounger
- Posts: 130
- Joined: 12 Aug 2020, 08:40
Re: Power BI
Hi Rory, thanks for your response. I know what you mean and I will try this! :) I've seen mention of this type of workaround before for categorising stuff in Excel.
I'm very new to Power BI and there's obviously so much to learn!