Forum Discussion

DK-C-87's avatar
DK-C-87
Helper I
1 year ago
Solved

Highlight in scatter plot using field parameter

I got this DAX formula to highlight dots in a scatter plot using 1 og 0 in conditional formatting.  It works great, except when I use the field parameter slicer to choose multiple filters   Highl...
Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    1 year ago

    DK-C-87 

    Measure:

    Highlight Valgte Muligheder =
    VAR Opslag = VALUES('Highlight indhold'[Valgmuligheder]) -- Captures all currently selected values
    VAR Business_Cases = IF(CONTAINS(Opslag, 'Highlight indhold'[Valgmuligheder], MAX(HighligtGBS[HL - Business Cases])), 1, 0)
    VAR Storbageri = IF(CONTAINS(Opslag, 'Highlight indhold'[Valgmuligheder], MAX(HighligtGBS[HL - Storbageri])), 1, 0)
    VAR Bageri = IF(CONTAINS(Opslag, 'Highlight indhold'[Valgmuligheder], MAX(HighligtGBS[HL - Bageri])), 1, 0)
    VAR Resultat = Business_Cases + Storbageri + Bageri
    VAR MultiResultat = IF(Resultat > 0, 1, 0) -- Assign 1 if at least one condition is met

    RETURN
    IF(
    HASONEFILTER('Highlight indhold'[Valgmuligheder]),
    Resultat,
    IF(ISCROSSFILTERED('Highlight indhold'[Valgmuligheder]), MultiResultat, BLANK())
    )

    Let me know if this resolves the issue!

     

    If this helped, a Kudos 👍 or Solution mark would be great!

    Cheers,

    Kedar Pande

    www.linkedin.com/in/kedar-pande

     
     

     

  • DK-C-87's avatar
    DK-C-87
    1 year ago

    Hi Again Kedar_Pande

    I thing i found the issue. It is because I have a colomn with three different department for each ID in the same tabel where I check for my Field Parameter such as "Business Cases" and "Storbageri" etc.
    The department is in a slicer, and when I select one department everything in your DAX formula works great !
    Could you please tell have to add to your DAX if all departments are selected in the slicer it return 0.
    So if there is non selected in the department slicer the measure should only give 1 to the ID's that have multiselected (F.eks. Business Cases and Storbageri) in the same department under each ID ?

    I really hope you can help me, because you are so close to the answer 🙂

Kedar_Pande's avatar
Kedar_Pande
Super User
1 year ago

DK-C-87 

Measure:

Highlight Valgte Muligheder =
VAR Opslag = VALUES('Highlight indhold'[Valgmuligheder]) -- Captures all currently selected values
VAR Business_Cases = IF(CONTAINS(Opslag, 'Highlight indhold'[Valgmuligheder], MAX(HighligtGBS[HL - Business Cases])), 1, 0)
VAR Storbageri = IF(CONTAINS(Opslag, 'Highlight indhold'[Valgmuligheder], MAX(HighligtGBS[HL - Storbageri])), 1, 0)
VAR Bageri = IF(CONTAINS(Opslag, 'Highlight indhold'[Valgmuligheder], MAX(HighligtGBS[HL - Bageri])), 1, 0)
VAR Resultat = Business_Cases + Storbageri + Bageri
VAR MultiResultat = IF(Resultat > 0, 1, 0) -- Assign 1 if at least one condition is met

RETURN
IF(
HASONEFILTER('Highlight indhold'[Valgmuligheder]),
Resultat,
IF(ISCROSSFILTERED('Highlight indhold'[Valgmuligheder]), MultiResultat, BLANK())
)

Let me know if this resolves the issue!

 

If this helped, a Kudos 👍 or Solution mark would be great!

Cheers,

Kedar Pande

www.linkedin.com/in/kedar-pande

 
 

 

DK-C-87's avatar
DK-C-87
Helper I
1 year ago

When I select "Business Cases" and "Bageri" it highlights 25 dots in stead of 4 - and the counter in the buttom left corner also counts 25 dots. But the real answer is 0 dots. 
If I change the Variable: 

VAR MultiResultat = IF(Resultat > 0, 1, 0) -- Assign 1 if at least one condition is met

To

VAR MultiResultat = IF(Resultat > 1, 1, 0) -- Assign 1 if at least one condition is met

It highlights 4 dots in the scatter plot and count 0 (the correct answer) in the buttom left corner. In other words, it sends me right back to where I started. 

I hope this maybe helps you to see a new solution ?

I need it to highlight 0 dots, same as the counter, because der is non of the ID's that have both "Bageri" and "Business Cases" - hope this clarifies it 

I have been struggling with this for 2 weeks know 🙂