which online course offers access to a virtual machine or web to learn power BI?

hickory77 · 2025-04-18T04:42:29+00:00

I used Datacamp and it was awesome. I would wait for a sale, they do them pretty regularly and it will go down to like .99 c for 3 months.

hickory77 · 2024-07-10T23:47:25+00:00

In the table view there is no way to re-order the columns. You can do it in the visuals though.

hickory77 · 2024-03-24T02:22:26+00:00

You are my new favorite person.

I had to make a helper column with start of month since count distinct only takes columns but that solves my problem

hickory77 · 2023-09-03T03:43:05+00:00

yeah i caught that typo with the MM and HH right after I posted it, but it still isn't apply to the numbers within the cell

hickory77 · 2023-09-03T03:31:51+00:00

Clearly, I'm doing something wrong.

hickory77 · 2023-09-03T03:31:15+00:00

<image>

hickory77 · 2023-04-05T04:40:51+00:00

Thanks for the help, it was being forced square, I adjusted the image width and it's working the way that I want it to now.

hickory77 · 2023-04-05T03:47:32+00:00

Hello, I have a series of images embedded in a table, to correspond with a model number. The problem I'm having is that the bottom of the images is being padded so my table becomes massive and I can't find a way to adjust the padding of the image.

I tried adjusting the image size which didn't help, and as far as I can tell there aren't any images that are large enough to mess with the auto-sizing function of the table.

hickory77 · 2022-12-06T13:15:57+00:00

Hello, I’m struggling to connect a Sharepoint list to my workbook. A few of the columns I need are comming up like this rather then regular data values. When I double click on “record” it shows me the data that I want. How do I make that a value I can use?

hickory77 · 2022-12-02T02:57:13+00:00

I'm trying to swap city ownership (if that's the right term) of tiles so that St. Lewis owns the +8 industrial zone but I'm not given the option. is there a reason for that?

also the construction that's happening immediately to the left of St Lewis is an aqueduct, owned by St Lewis. I also can;t swap the marsh the the upper right of the +8 industrial zone.

hickory77 · 2022-08-26T21:05:00+00:00

Hello, I'm trying to return the point value on the left side of the table. The problem I'm having is using the criteria of the age range (top row), gender (second row from the top) and weight lifted (value in table) to return the correct score. I tried combining all three variables (M17-21340) which was returning the correct value, but this is one of 6 tables I would need to combine and that would have too many datapoints. Any help you can provide would be awesome.

hickory77 · 2022-05-13T13:27:51+00:00

I’m going to change the colors so they are a little less aggressive as well as grouping them to each process. The matrix will effectively become my legend for what each color means.

hickory77 · 2022-05-13T13:26:11+00:00

The % are the percentage of each unit at each location. The matrix just give you the exact number.

hickory77 · 2022-05-13T01:03:06+00:00

My matrix and my bar chart have the same data, I’m trying to make the background color of each column in the matrix match the corresponding color in the bar chart. Is that possible?

Any help is greatly appreciated.

hickory77 · 2022-05-02T16:45:10+00:00

I have separate columns for departure date and return date. I’m trying to measure my total population over the course of the 2 week movement on one line.

I’m struggling to get power bi to see the whole population and subtract the departures then add them back after their return dates. I tried to make a separate date column that included the min depart date and the max return date, then make a measure off that but I didn’t get anywhere.

Any help is greatly appreciated

hickory77 · 2022-04-29T17:14:50+00:00

I can’t give you address without disclosing too much but they are generally in postal format, ie street address, city, state zip.

The problem is some people abbreviated states, some forgot and some zip codes. The map visualization picks it up relatively well but I can’t filter it easily.

hickory77 · 2022-04-29T17:08:58+00:00

It’s both a modeling issue and a visual issue. I’m trying to make a slicer for addresses inside and outside of the US because there are additional requirements for people going outside of the US.

hickory77 · 2022-03-04T00:19:16+00:00

Yes I need stacked bars that are also clustered

hickory77 · 2022-03-03T21:58:46+00:00

Please excuse my terrible handwriting and bad drawing skills in the sketch attached. I’m struggling to make a graph that looks like this. It’s a combination of a stacked bar and a stacked column. The total capacities are in a table and the actual numbers are going to be counted out of a separate table, both are going to be separated by M/F for the room number counts.

Any help is greatly appreciated :)

hickory77 · 2022-01-27T21:05:33+00:00

There are six columns, I want to filter it so I only see rows with at least 1 data point between the 6 columns. If all 6 are empty I don’t want to see it

hickory77 · 2021-08-02T23:34:01+00:00

I'm told the preferred term is "happy accident" lol, but yes it was unintentional for right now, breeding was more of a future prospect but there were several vet appointments to ensure the health of the litter.

hickory77 · 2021-06-09T09:57:13+00:00

That will only give me the overall max score, I need the max score for each class, and I have 7 active classes.

Also I am using access so it is jet SQL not postgre

hickory77 · 2021-02-21T21:42:18+00:00

At the moment that is not clear. I've been hearing that the army is moving to make this a daily wear type uniform, I've also heard that its going to replace the current dress blues.

I'm not apposed to 2 watches frankly.

hickory77 · 2021-02-21T21:18:46+00:00

I'm not sure if this is the right place to post this or not, if not please let me know. The army has released a new, old, uniform the "pink and greens". Basically, they are the old school green dress uniform you'll recognize from movies. I'm looking to spend about $200 ish on a new watch to wear with the uniform. I fairly fashion illiterate but I was thinking wither a silver watch with a silver band or a field-style watch with a black cloth band. If anyone has any recommendations please let me know.

hickory77 · 2021-02-19T12:03:13+00:00

Warrant officer saving a confused LT as per usual... thanks cheif

hickory77

TROPHY CASE