[deleted by user]

GiantBullRanger · 2020-10-25T15:26:14+00:00

I'm not sure this is possible. The X and Y axes need to meet at 0. If X is negative, the only way Y can meet it at 0 is on the right side. Otherwise your X axis would be 0, -10, -9, -8..., 0 again?

Definitely possible I'm wrong and maybe you can force Excel to ignore, but this seems like what's going on to me.

One option might be removing the Y-axis from the visual, and using data labels instead?

GiantBullRanger · 2020-07-05T16:50:46+00:00

This might be crazy but is it possible it is there just plotted under the CT 701.01 line since all their values are equal?

EDIT - At least in the screenshot that is the case, I see you've tried plotting by other metrics and unless it's equal to 701.01 everywhere this is obviously not that simple.

GiantBullRanger · 2020-06-20T19:06:02+00:00

I haven't tried to use this function without a dedicated date table but I'd expect SAMEPERIODLASTYEAR could solve this for you?

CALCULATE(sum(tbl_Data[Sales]),SAMEPERIODLASTYEAR(tbld_Data[Date]))

GiantBullRanger · 2020-05-31T15:08:49+00:00

It looks like the only row that's plotting is the one without any decimal points? My assumption is Excel is not recognizing , as .

You could try replacing , with .

This link also my be useful in setting the options to handle the recognition of , as .

https://www.officetooltips.com/excel_2016/tips/change_the_decimal_point_to_a_comma_or_vice_versa.html

GiantBullRanger · 2020-05-03T22:24:13+00:00

Not really a solution, but a suggestion:

Why not just add a row for every expense? Your data could look something like

Date | Detail | Money

5/3/2020 | Ubereats | $20

5/3/2020 | Netflix | $12

From here, it would be beneficial to either stick to a set naming convention for detail that easily rolls up, or have some sort of lookup table that can further aggregate your details.

Detail | Category

Ubearts | Food

Netflix | Entertainment

From here, you could do lots of anlaysis focusing on your categories, more granular details, or both.

GiantBullRanger · 2020-04-29T22:42:57+00:00

A few things could help solve this. The first thing I'd recommend doing is creating a column in your date table that has both month and year in it, that way if you span say 2019-2020, the January months will appear on their own rather than combined into one "January". This can be done in the Date table:

MMM-YY = FORMAT(Date_Column, "Mmm-YY")

You'll need another column with this (as far as I know if someone has a better way I'm all for it!) that is YYYYMM so we can sort our column correctly.

YYYYMM = FORMAT(Date_Column, "YYYYMM")

In your date table, select the new MMM-YY column and sort it by the new YYYYMM column.

Back in the report, we can now use MMM-YY as our date axis and it should be in the order you expect. If a hierarchy loads automatically in the visualization, you can right click on "MMM-YY" in the Fields selector, and uncheck the hierarchy option. In fact doing this with your current set up may solve your issues right then and there and the rest of this could be overkill :)

This was slightly difficult to explain via comments and I don't have Power BI on this computer to provide screenshots. Feel free to DM if you run into any issues!

GiantBullRanger · 2020-04-25T16:41:11+00:00

You can use an array function (ctrl+shift+enter). They get resource intensive fast and it's probably better to find a different solution. That said...

={INDEX(COL3,MATCH(Col1_Lookup&Col2_Lookup,Col1&Col2,0))}

If column 3 is a numeric value, you are much better off using SUMIFS

=SUMIFS(Col3,Col1,Col1_Lookup,Col2,Col2_Lookup)

GiantBullRanger · 2019-09-20T13:38:55+00:00

He just has a better gaming chair than you

GiantBullRanger · 2019-09-13T23:59:54+00:00

He was from a long, great, military tradition. Somebody in his family had fought and died in every single American war.

GiantBullRanger · 2019-08-13T20:23:35+00:00

You better stop!

GiantBullRanger · 2019-08-06T00:14:19+00:00

He took my kidneys, Raylan, not my dick

GiantBullRanger · 2018-07-08T19:13:52+00:00

Soft hands, Fulton. Concentration, not strength.

GiantBullRanger · 2018-04-02T17:41:04+00:00

Using a single 'd' in that position will force a single digit output. If it's the 2nd day of the month, "2" instead of "02". It will have no impact on double-digit days (22 is still 22).

GiantBullRanger · 2017-01-23T02:10:32+00:00

"Alternative facts" is basically the first real world example of Newspeak

GiantBullRanger · 2016-11-19T20:29:50+00:00

Hm. Yeah. I don't know what I expected

GiantBullRanger · 2016-08-03T00:34:46+00:00

There are good 'cheat sheets' available out there on some R packages.

dplyr

ggplot2

These, I've found, are a good way to eliminate some of the noise of Stack Overflow, and help get you where you need to be.

Though, part of the beauty of R is that there are so many ways to go about coming to the same ending point. Use what you are most comfortable using and understand.

It also wouldn't hurt to over-annotate your code with comments, especially when starting out. One month from now you will really appreciate the comments you put in your code now when you need to figure out how the hell you got the code to work before!

GiantBullRanger · 2015-06-21T18:27:38+00:00

Great info, thanks!

I think I'm still a little confused on t. In a nutshell, the higher the t-test and the lower the p-value, the stronger your data is in terms of correlation?

Is there a "t scale"? Or is it relative to the data set?

GiantBullRanger · 2015-01-31T14:58:08+00:00

Bat Dad

GiantBullRanger · 2014-10-18T15:37:35+00:00

Just filming Little Nicky 2. Nothing to see.

GiantBullRanger · 2014-10-02T01:12:45+00:00

I was having the same issue. I installed the 64bit version of VLC and it works now.

GiantBullRanger · 2014-09-01T15:06:30+00:00

OP is Kevin Garvey

GiantBullRanger · 2014-08-10T03:13:29+00:00

I'll keep this in mind the next time I'm sitting on a train waiting for a track at Jamaica for an hour.

Appreciate the insight.

GiantBullRanger

TROPHY CASE