Gráfica de días vs año

[alfertab]

Hola a todos, tengo un problema y me gustaría ver si alguien sabe cómo puede resolverse.

Básicamente tengo una tabla como la siguiente:

Fecha	Día	Año
01/02/2018	01 de febrero	2018
04/03/2018	04 de marzo	2018
18/06/2018	18 de junio	2018
25/01/2019	25 de enero	2019
13/04/2019	13 de abril	2019
22/09/2019	22 de septiembre	2019
02/03/2020	02 de marzo	2020
03/06/2020	03 de junio	2020

Con eso, yo busco lograr una gráfica como la siguiente: 

alguien sabrá como hacerlo?

[skygold16 · Accepted solution]

Hello, 

If I understand correctly, what you are trying to do is creating a scattered chart. In Power BI, you can only use numeric values for this visual. Alternatively what you can do it to use the metrics visual and follow below:

• Add custom column with value as 1 (dummy) or generate the values based on certain condition to be able to set up conditional formatting rule
• Use this column in value field of metrics 
• do a conditional formatting to choose appropritate icon 
• chnage the value font colur to match with you background so that values are not visible

And it will look something like below:

[alfertab]

@v-zhouwen-msft @skygold16 Thanks both of you, both methods were succesfull. I personally used the method of @v-zhouwen-msft , but both were usefull. Thanks a lot 😄

[v-zhouwen-msft · Accepted solution]

Hi @skygold16 ,thanks for the quick reply.

Hi @alfertab ,

The Table data is shown below:

Please follow the step:

1.Creating a Scatterplot Visual Object

Scatter, bubble, and dot plot charts in Power BI - Power BI | Microsoft Learn

2.Final output

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

[skygold16 · Accepted solution]

Hello, 

If I understand correctly, what you are trying to do is creating a scattered chart. In Power BI, you can only use numeric values for this visual. Alternatively what you can do it to use the metrics visual and follow below:

• Add custom column with value as 1 (dummy) or generate the values based on certain condition to be able to set up conditional formatting rule
• Use this column in value field of metrics 
• do a conditional formatting to choose appropritate icon 
• chnage the value font colur to match with you background so that values are not visible

And it will look something like below: