cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Use of a slicer to display only the newest values according to the already slected other slicer

Hey 🙂

I have a new challenge.

 

I want to exhibit the newest rows of a table in a visualsiation table in the reporting view, only if the according slicer is selected. If not, the rows according to all the other slicer should appear. Until now, I only manage to show the values of the newest values thanks to this measure and through the filter pane where only the "1" of this measure displayed:

ActualityMeasure =
var Auswahl = MIN(AktuelleMessdaten[Aktuelle Messwerte])
VAR latestdate_ =
CALCULATE ( MAX ( Messdaten_Entpivotiert[Datum] ); ALLEXCEPT (Messdaten_Entpivotiert; Messdaten_Entpivotiert[CAD-NR.]) )
RETURN
IF ( MAX ( Messdaten_Entpivotiert[Datum] ) = latestdate_ && Auswahl = "Jüngste Messwerte";1;IF ( Auswahl = "Alle Messwerte";1;0))

 

 

I want that if var Auswahl is "Alle Messwerte", that all the rows of the other already applied slicer are displayed and when the var Auswahl is "Jüngste Messwerte" the selection is filtered down to the newest rows (this part works fine). Unfortunately now if var Auswahl is "Alle Messwerte", all the other slicer are overruled and I get all rows.I'd grateul for any help, thanks in advance 🙂

 

4 REPLIES 4
Highlighted
Community Support
Community Support

Hi @Volki 

I build a sample  table to have a test.

Messdaten_Entpivotiert:

1.png

AktuelleMessdaten:

2.png

I tried your measure and it works well, you may try to change min as selectvalue and try again.

ActualityMeasure = 
var Auswahl = SELECTEDVALUE(AktuelleMessdaten[Aktuelle Messwerte])
VAR latestdate_ =
CALCULATE ( MAX ( Messdaten_Entpivotiert[Datum] ), ALLEXCEPT (Messdaten_Entpivotiert, Messdaten_Entpivotiert[CAD-NR.]) )
RETURN
IF ( MAX ( Messdaten_Entpivotiert[Datum] ) = latestdate_ && Auswahl = "Jüngste Messwerte",1,IF ( Auswahl = "Alle Messwerte",1,0))

Result:

Aktuelle Messwerte = Alle Messwerte and CAD-NR. = UUR0033.png

Aktuelle Messwerte = Jüngste Messwerte and CAD-NR. = UUR003

4.png

If this reply still couldn't help you solve your problem, please show me your data model and the screenshot of your problem.

Or you can share your pbix file with me by your Onedrive for Business.

 

You can download the pbix file from this link: File

 

Best Regards,

Rico Zhou

 

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

Highlighted

Hey & thank you, this works for me!

 

Now the table is showing the right rows. Unfortunately I have a diagram next to it, which shows everything while the slicer option "All Daten" is checked, but if the slicer option "Jüngste Daten" is checked, nothing is displayd. 

 

How can I get the new data on the diagram as well?

I already tried to implement the data filter, (while Actuality Measure = 1) but it doesn't work.

 

Any hints?

Thanks in advance

Highlighted

Hey,

 

has anybody a hint how to display data in a diagram, when it is filtered by a combination of slicer & and filter (when measure XX = 1) ??

 

Thanks in advance

Highlighted
Community Support
Community Support

Hi @Volki 

I think you need to build this diagram by Datum ,CAD-NR. column and other columns. (We build the measure by these two columns.)

If you do so , then drag the measure into Filter Field and set it to show items when measure = 1 and it still show empty without the latest value in this diagram when you select "Jüngste Daten" in slicer, there may be something wrong in this measure. All values in this measure may return to 0.

Due to I don't know about your table and data model, please show me a sample about your data ,a screenshot of your issue and the result you want.

And you may tell me how did you build this diagram, such as which column you use to build it.(a screenshot may be better)

Or you can provide me with your pbix file by your OneDrive for Business.

 

Best Regards,

Rico Zhou

 

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors