User Profile
Lovebo01
Helper I
Joined 6 years ago
User Widgets
Contributions
"View errors" disappear in new versions of Power BI Desktop
Hello, In the previous version like August 2020 version of Power BI Desktop, when you load some data and close and apply the query editor. And you have some errors from Power Query editor it shows you "View errors" like this : But now it's showing nothing and replace errors directly by null value. How to get this pop-up again in the last version of Power BI Desktop ? Thank you, LoveboRe: TotalYTD with start date and end date
Hello Stachu, Thank you for your answer, in fact I need to add a start date and an end date. With the classic DatesYTD() or TotalYTD() functions we can only add an end date which is also the start date (D+1) in fact. So for example my start date should be 1st february (01/02/2015) and me end date 31st August (31/08/2017). So with the data that I sent, we should have this result : Thank you again for your help, LoveboRe: TotalYTD with start date and end date
Hello Stachu, Yes of course : Year Qtr Month Sales 2015 3 7 10 2015 3 8 10 2015 3 9 10 2015 4 10 10 2015 4 11 10 2015 4 12 10 2016 1 1 20 2016 1 2 20 2016 1 3 20 2016 2 4 20 2016 2 5 20 2016 2 6 20 2016 3 7 20 2016 3 8 20 2016 3 9 20 2016 4 10 20 2016 4 11 20 2016 4 12 20 2017 1 1 30 2017 1 2 30TotalYTD with start date and end date
Hello everyone, I am looking for a TotalYTD() function with a start date and an end date. I tried with a Flag_Start_Date with some If but I wasn't able to find the answer. The Start date should be always "01/09" And the End date should be the last date (DD/MM) of data. For example If I have some data from 01/01/2015 to 01/02/2017 (DD/MM/YYYY format) I want be build a table visualization like this : Year Qtr Sum Sales YTD Sales fiscal 2015 1 10 10 2015 2 10 2015 3 10 10 2015 4 10 20 2016 1 20 40 2016 2 20 2016 3 20 20 2016 4 20 40 2017 1 30 70 2017 2 30 2017 3 30 30 2017 4 30 60 I don't add Month column to not have to many rows in my table. Is it possible ? Thank you for your help, Regards, LoveboRe: Gráfico de dispersión Eje X con valor de texto
Hola Gracias a todos por sus respuestas, Aquí un conjunto de datos : Tamaño Color Ventas 1 Rojo 30 2 Azul 5 3 Rojo 25 4 Azul 12 Y el gráfico que quiero hacer : El tamaño de la burbuja depende del valor "ventas". @fhill Traté de aplicar su solución con el gráfico de líneas, pero con 2 ejes no sé si es posible, el tamaño del marcador puede depender de otro valor ? Gracias LoveboRe: Scatter chart X-axis with text value
Hi, Thank you all for your responses, Here a set of data : size color sales 1 red 30 2 blue 5 3 red 25 4 blue 12 And the graphic that I want to do : The size of the bubble depends on the value "sales". fhill I tried to apply your solution with the line chart but with 2 axis I don't know if it's possible, the size of the marker can depends on another value ? Thank you, Lovebo
