Forum Discussion
Matrix displays repeated values in every column
Hi everyone,
So, I end up finding the solution by myself (and a little help from Chat GPT lol).
I've decided to use only one data-set column on Value field, this column gathers all dates for every case (Original, Previous, and Actual).
Then I've decided that the "Previous" info wasn't necessery for our report. With that decision made, i've writen the following dax:
Icon_Imp_Atual_BL2 =var filtro = SELECTEDVALUE('d_EAP_Códigos_Fases'[Fase])returnIF(MAX(d_EAP[BaselineNumber]) = 2,SWITCH(TRUE(),filtro = "Engª Conceitual / Básica",[Icon_Imp_Engª Conceitual / Básica],filtro = "Aprovação da HA",[Icon_Imp_Aprovação da HA],filtro = "Engª Detalhada",[Icon_Imp_Engª Detalhada],filtro = "Planejamento (Aquisições e Contratações)",[Icon_Imp_Planejamento (Aquisições e Contratações)],filtro = "Execução Início",[Icon_Imp_Execução Início],filtro = "Execução Término",[Icon_Imp_Execução Término]),[Icon_Início])Those measures are images urls, that will return the icons on the matrix.At the end, i've just used thar measure as a Cell Element Icon function and there we've got the result:
Super UserHi Anonymous ,
Struggling in getting how your setup is puicking up the actual vs previous.
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Hi Miguel,
Thanks for trying to understand my issue.
I'm sending you the file via private message
Summing all up, this matrix has 3 columns (Original date, Previous date, and Actual date), and rather than returning these dates on the matrix, I want to display icons that are calculated by an switch dax code, triggered by the "Fase de Entrega" Filter. These icons have different colours, the original is a system default Star, the Previous should display red icons, as the Actual are green.
The main trouble is, for exemple,if I have these dates:
Original (01/01/23);
Previous (01/02/23);
Actual (01/03/23)
the matrix is displaying the icons like that:
| 01/01/23 | 01/01/23 | 01/01/23 | 01/02/23 | 01/02/23 | 01/02/23 | 01/03/23 | 01/03/23 | 01/03/23 |
| Original | Previous | Actual | Original | Previous | Actual | Original | Previous | Actual |
| ⭐ | 🔴 | 💚 | ⭐ | 🔴 | 💚 | ⭐ | 🔴 | 💚 |
but the way it supposed to:
| 01/01/23 | 01/01/23 | 01/01/23 | 01/02/23 | 01/02/23 | 01/02/23 | 01/03/23 | 01/03/23 | 01/03/23 |
| Original | Previous | Actual | Original | Previous | Actual | Original | Previous | Actual |
| ⭐ | 🔴 | 💚 |
Hi everyone,
So, I end up finding the solution by myself (and a little help from Chat GPT lol).
I've decided to use only one data-set column on Value field, this column gathers all dates for every case (Original, Previous, and Actual).
Then I've decided that the "Previous" info wasn't necessery for our report. With that decision made, i've writen the following dax:
Icon_Imp_Atual_BL2 =var filtro = SELECTEDVALUE('d_EAP_Códigos_Fases'[Fase])returnIF(MAX(d_EAP[BaselineNumber]) = 2,SWITCH(TRUE(),filtro = "Engª Conceitual / Básica",[Icon_Imp_Engª Conceitual / Básica],filtro = "Aprovação da HA",[Icon_Imp_Aprovação da HA],filtro = "Engª Detalhada",[Icon_Imp_Engª Detalhada],filtro = "Planejamento (Aquisições e Contratações)",[Icon_Imp_Planejamento (Aquisições e Contratações)],filtro = "Execução Início",[Icon_Imp_Execução Início],filtro = "Execução Término",[Icon_Imp_Execução Término]),[Icon_Início])Those measures are images urls, that will return the icons on the matrix.At the end, i've just used thar measure as a Cell Element Icon function and there we've got the result: