FAQ: Ask Amanda Anything Questions & Answers

Hi EStieg ,

It is helpful, and thank you for sharing.

Best Regards,

Amy

Community Support Team _ Amy

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

Hi ESteig,

I was on the Ask Amanda Anything call, but was not able to submit questions. It seems in the forums like others were having this issue. Just want you to be aware so that hopefully it can be corrected for the Ask Amir Anything.

Thanks,

Scott

Thanks for this EStieg, very helpful to have this as a file to share/be able to search through after the event.

Hi,

The link to the roadmap brings me to the release notes of Oktober 2018?

Cant seem to find that roadmap myself. Any working link ? 

Robbe

Hi Amanda or anyone who can help me!

I want to use a stacked area chart visualization with a total amount value vs. date axis. The problem is that when I apply a date axis , it only shows data for a minor total amount. My total is 40 thousand, and once applied the date it turns down to 16. This happens with different dates and it turns down different quantities.

How is that possible?

Thanks in advance!

Agustín

Dear Amanda

I have used TotalYTD to calculate accumulative revenue by month.

But Unfortunately, the result is not correct. YTD amount is as same as MTD amount.

The relationship with calendar table is already established.

I would like to attached file in below link.

Can you help me to fix this error.

https://drive.google.com/open?id=1ubYox2s3f1LvsryML93GLgkL_A52iqC3

Hi Amanda,

I have set up a report which has a preset filter on geography (eg England) 

On page 3 of the report I want to show where England ranks out of all the countries in Europe so I have turned off the relationship from the filter to the bar chart. 

Is there a way to use conditional filtering to change the colour for England so it stands out?

FYI the "England" filter is changeable so I can't put direct text into the conditional format

Any help would be great - I am currently looking at the isfiltered dax function

Chris 

Hi,

is there any way to remove data from a created chart?

I mean, I created a pie chart and it shows the values and the %-es. Is there a way to show either the values (and format them as needed) or just the %-es, but not both?

Many thanks and best regards

Hi Amanda,

Is it possible now to do Forecasting using ARIMA model in DAX for Power BI Desktop? So far I am directed to using R script from this thread: https://community.powerbi.com/t5/Desktop/quot-Forecasting-with-ARIMA-quot-in-Table-Visual/td-p/88666....

What I want to do is as follows:

1. Show 60 days worth of data in a bar graph.

2. In the same graph as #1, draw a line for the moving average for 10 days of actual data.

3. Forecast the future next 10 days using the 60 days data and using ARIMA model, then show the results as extension to the line drawn in #2.

Currently, I am already able to achieve #1 and #2 above using DAX and "Line and clustered column chart" Visual. I already was able to get the forecast values using R script. My problem is I cannot transform the resulting data from R and load it as Modelling Data in Power BI so I can use the results in Dax. If I won't be able to do #3 via DAX, then I have to proceed doing everything in R script. That's where I am currently.

Any advice or feedback will be much appreciated.

EStieg 

Thank you for sharing!!