Use of a slicer to display only the newest values according to the already slected other slicer
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:
var Auswahl = MIN(AktuelleMessdaten[Aktuelle Messwerte])
VAR latestdate_ =
CALCULATE ( MAX ( Messdaten_Entpivotiert[Datum] ); ALLEXCEPT (Messdaten_Entpivotiert; Messdaten_Entpivotiert[CAD-NR.]) )
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 🙂
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.
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.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.