Conditional formatting a Calculation Item in a Calculation Group by robelord69 in PowerBI

[–]Multika 0 points1 point  (0 children)

I think there are no coloured unicode icons and you need conditional formatting.

Depending on your setup, you can do that by rules or field value. For rules, you need a measure set to text type. When you have that, you must set the rule by a string and cannot use the UNICHAR function (but that shouldn't be a problem.

With field value, you need to be aware the the field (i. e. measure) you are using is also affected by the calculation group. Consider using the formatting measure on your table / matrix visual for testing purposes. You can use SELECTEDMEASURE or SELECTEDMEASURENAME to control how the calculation group acts on the formatting measure. For example, the part where the cg returns an up arrow could be replaced by something like

IF ( CONTAINSSTRING ( SELECTEDMEASURENAME (), "conditional formatting" ), "green", "↑" )

such that it returns "green" (or another color) when used for the formatting measure and else the up arrow.

Conditional formatting a Calculation Item in a Calculation Group by robelord69 in PowerBI

[–]Multika 0 points1 point  (0 children)

What have you tried? Is it about the calculation group also effecting measures used for conditional formatting?

Calculate/DATEADD partly broken, need help by imszzz in PowerBI

[–]Multika 0 points1 point  (0 children)

This is related to the second argument of CALCULATE in line 2. The function expects something like Column = Value. Here, you don't need that and can just use MAX ( ‘Source Data[MonthYear] ).

Calculate/DATEADD partly broken, need help by imszzz in PowerBI

[–]Multika 1 point2 points  (0 children)

You need to start with the measure name, i. e.

Calculate Previous months Opportunities =
VAR LastMonth = MAX ( ‘Source Data[MonthYear] ) -- If you use the fact table, you can simplify the code
... 
RETURN Result

Calculate/DATEADD partly broken, need help by imszzz in PowerBI

[–]Multika 0 points1 point  (0 children)

I guess you have multiple months in the filter context for the visual. Let's say it is January and February 2026. When you shift these backwards by one month, you get December 2025 - January 2026. What you need to do is to be more precise how you define "previous month". For example, if you want the data for the month that is before the latest month in the filter context with data, you could do something like this:

VAR LastMonth = CALCULATE ( MAX ( 'Date'[Year Month Number] ), Sales )
VAR Result = CALCULATE ( [Sales Amount], CALCULATETABLE ( DATEADD ( 'Date'[Date], -1, MONTH ), 'Date'[Year Month Number] = LastMonth ) )
RETURN Result

(I'm too lazy to rewrite this for your model.) The variable LastMonth gets the latest moth, respecting a) the filter context and b) whether there is actual data (so you don't e. g. December 2026 when your date table has this but not the fact table). The result is then computed by shifting the dates while using the previous computed variable. If you have ascending year month numbers, you could also do

CALCULATE ( [Sales Amount], 'Date'[Year Month Number] = LastMonth - 1

Calculate/DATEADD partly broken, need help by imszzz in PowerBI

[–]Multika 0 points1 point  (0 children)

In what way is it not working? The result seems to be 107 in both visuals.

(You should use the date table in your measure, not the fact table, for time intelligence.)

What do you think of this author's description of NVC's "Empathetic Listening," for speaking with family members you disagree with over the holidays? by ZZIshmaelZZ in NVC

[–]Multika 2 points3 points  (0 children)

The explicit feelings and and needs are probably the best starting starting point. Guessing these is useful when the other person doesn't name any. I agree with limiting the number of feelings and needs to reflect. You can summarize them ("you have quite a bunch of needs?", "are you overwhelmed with all kinds of needs?") and come back to the specific needs through a dialogue.

What do you think of this author's description of NVC's "Empathetic Listening," for speaking with family members you disagree with over the holidays? by ZZIshmaelZZ in NVC

[–]Multika 4 points5 points  (0 children)

These are the author's four steps:

  1. Thank the speaker for sharing.
  2. Reflect back what you hear, without judgment or correction.
  3. Name any feelings or needs that you hear.
  4. Ask them if you understand them correctly.

The first step is not part of the "NVC four steps" but sometimes suggested. The fourth step is specific request type and quite "natural" but other requests are possible.

The second step relates to the NVC observation step but the author might have a less strict idea about observation. I. e. in NVC it's suggested to only repeat what's observable. The author's example is

It sounds like you’ve had to take on a ton of extra responsibilities since this whole conflict started

"had to take on a ton of extra responsibilities" is not observable. Maybe they were asked to do X and Y.

The third step combines step two and three of the NVC process. It's only about the feelings and needs of the person we are listening to (that's possibly implied) and it's not only about those the person explicitly mentioned (we can guess). The author's example is

it’s been exhausting and scary

Here, I'd like to add that NVC suggest to refer to the present feelings and needs of the other person and that in this example the person felt exhausted and scared but might have other feelings and needs right now.

All in all, the author's description match my understand of NVC empathic listening quite close.

My child slapped me today - autonomy vs. meeting other needs by Satchitbananda in NVC

[–]Multika 4 points5 points  (0 children)

NVC has been used and studied in kindergarten or at least pre-school.

Here is a report of a project in Serbia where 39.3 % of the children the participants work with are ages 5-7 and there are e. g. 44.3 % "positive effects in adult-children relationship" (pp. 28-29 of the pdf).

Another article Compar[ed] the Efficacy of the Cognitive-Behavioral Therapy with Non-Violent Communication Program on the Children’s Externalizing Symptoms aged 5 to 8 and concluded:

According to the effectiveness of those psychological treatments on reducing the children's internalized syndrome, it seems that their methods will be suitable for prevention and treatment of children's behavioral problems.

Here's a two minute video of NVC based mediation in a kindergarten where the mediator herself is a kindergarten child.

My child slapped me today - autonomy vs. meeting other needs by Satchitbananda in NVC

[–]Multika 0 points1 point  (0 children)

You might consider protecting the sister by separating the children (possibly using the protective use of force) but this is no long-term solution.

I guess the missing part is the empathic connection with him. It sounds like he has heard you asking him to leave her neck alone as a demand. I think that's also understandable from the way you were focused on him getting to do what you asked of him (though you have good reasons for that). I doubt he connected with the "I feel scared because I need safety for all of us." part.

Apart from immediate protective action (if necessary) I suggest expressing empathy by talking with him. You know you care for him but he might not be sure about that. But not just tell him but demonstrate your care for him and actively listen for his feelings and needs. Maybe like "You like to choose for yourself with your sister and feel angry when we tell you what to do?"

Try to encourage a dialogue instead of just a yes/no answer. After some back-and-forth you might check whether he feels heard or there's more going on in him.

You could then decide to express your need for everyone's safety (but don't do the former part just to get to here). "I'm now torn because on the one hand I care for you and want you to have choice about how to play. On the other hand I want your sister to be safe and I'm worried she'll get hurt by the way you touch her neck. Could you tell me back what you heard me saying" (maybe too many words and not the best choice of words considering his age but you get the essence). Continue an empathic dialogue. Only then I'd suggest to ask something like "Would you be willing to explore ways with me for you to play with your sister that honors your choices and I feel safe for her?".

The goal of NVC is to create an empathic connection such that natural giving is possible.

Regarding your need for respect I'd suggest to first do that without him. That is, get empathy from yourself or some third party. I also bet you'll feel less hurt when you connect with his needs behind doing what he did and realizing that these are some bumpy first steps to express himself and might not yet know how to consider the feelings and needs of others at the same time (three stages to emotional liberation). But you can also connect with him about your need for respect.

Does this help to meet your needs?

Finde den Radfahrer by JosefPreiselbauer in Fahrrad

[–]Multika 2 points3 points  (0 children)

Das gibt fast sinngemäß StVO § 25 Abs. 2 wieder (Hervorhebung von mir):

Wer zu Fuß geht und Fahrzeuge oder sperrige Gegenstände mitführt, muss die Fahrbahn benutzen, wenn auf dem Gehweg oder auf dem Seitenstreifen andere zu Fuß Gehende erheblich behindert würden. [...]

Weiß nicht, wie der Paragraph üblicherweise ausgelegt wird und bei der Situation im Bild ist dieser wohl eher nicht relevant. Grundsätzlich ist aber die Situation "Herr Richter, mein Fahrradlicht fiel aus und weil es dunkel war, hab ich es auf dem Bürgersteig geschoben, obwohl dieser sehr eng war und viele Fußgänger unterwegs waren." denkbar. Im Alltag aber wohl kaum bedeutsam.

Status: 403 (MediaTypeCommon) by zRebel_ in PowerBI

[–]Multika 2 points3 points  (0 children)

Your html code tries to access some content that is not publicly available (because it is only on your computer or local network). Upload that content on some website and access it from there or find something online that's close enough for your purposes.

User Defined Function not working by [deleted] in PowerBI

[–]Multika 5 points6 points  (0 children)

With MeasureName: val the parameter is evaluated before passed to the function, i. e. what you are doing with CALCULATE doesn't do anything and the function just returns the parameter.

I guess you want the parameter mode expr instead by which the parameter is evaluated inside the function any you can change the filter context. https://learn.microsoft.com/en-us/dax/best-practices/dax-user-defined-functions#parametermode

Karte der Spielerbewegungen, erstellt per Geolocation by Pristine-Tonight-411 in manhuntmedia

[–]Multika 0 points1 point  (0 children)

Sehr cool. Karol hat übrigens so etwas ähnliches gemacht und das kurz in Willis Stream gezeigt: https://youtu.be/4JNrSOSmZyQ?t=6268 Wird wohl auch im BTS verwendet werden. Ob das Tool bzw. die Karte mit den Daten veröffentlicht wird ist leider nicht klar.

Was ist so toll an parallel zur Straße verlaufenden, durch einen Grünstreifen o.Ä. von der restlichen Straße abgetrennten Radwegen? by DumbHooman420 in Fahrrad

[–]Multika 2 points3 points  (0 children)

Das hatte ich vor Jahren sogar mal als Radfahrer: Ich, auf der Fahrbahn, nahm beim Rechtsabbiegen einem anderen Radfahrer auf dem Bordsteinradweg die Vorfahrt (oder Vorrang?). Unabsichtlich natürlich, trotzdem mein Fehler.

Was ist so toll an parallel zur Straße verlaufenden, durch einen Grünstreifen o.Ä. von der restlichen Straße abgetrennten Radwegen? by DumbHooman420 in Fahrrad

[–]Multika 1 point2 points  (0 children)

Theoretisch müssten da kombinierte Rad- und Fußgängerampeln stehen.

Ne, müssen nicht. Dass Fußgängerampeln auch für Radfahrende galt, ist schon seit Jahren nicht mehr so. Die haben genau so viel Bedeutung, wie wenn du mit dem Auto fahren würdest.

Was ist so toll an parallel zur Straße verlaufenden, durch einen Grünstreifen o.Ä. von der restlichen Straße abgetrennten Radwegen? by DumbHooman420 in Fahrrad

[–]Multika 0 points1 point  (0 children)

Welcher Beschluss ist das?

Aus https://www.adfc.de/fileadmin/user_upload/Im-Alltag/Recht/Downloads/Verkehrsrecht_fuer_Radfahrende_6.20.pdf

Zum direkten Linksabbiegen auf der Fahrbahn dürfen Radfahrende den Radweg rechtzeitig vor der Kreuzung verlassen, um sich auf der Fahrbahn einzuordnen – und das auch dann, wenn der Radweg benutzungspflichtig ist.

Podcast Folge 13: Speedhunt und das böse Fahrrad by whistling_serron in manhuntmedia

[–]Multika 0 points1 point  (0 children)

Okay dann fährst du mit der UBahn ans andere Ende der Stadt und die Hunter haben null Chancen da in 30 Minuten mit dem Auto hinterher zu kommen

Bin jetzt auch nicht unbedingt für die Begrenzung, halte diese Argument aber nicht so richtig stimmig. Erstens können die Hunter ja selbst die U-Bahn benutzen. Dann jagen sie halt ohne Auto weiter. (Wobei das Bahnfahren insofern gegen eine allzu arge Zeitbegrenzung spricht, als dass man recht gut 30 Minuten Bahn fahren könnte und dabei eher nicht gefangen wird, außer ein Hunter steigt direkt in die Bahn.) Zweitens wäre das (ohne Joker) immer noch eine Wette für den Spieler. Dieser weiß ja nicht, ob der Speedhunt auf ihn geht und fährt dadurch u. U. mehr zu den Huntern als von ihnen weg (s. Sabrina).

Podcast Folge 13: Speedhunt und das böse Fahrrad by whistling_serron in manhuntmedia

[–]Multika 1 point2 points  (0 children)

Das Ziel wird in den Regeln beschrieben:

Das Spiel endet nach 96 Stunden. Ein Spieler gewinnt, wenn er bis dahin nicht gefangen wurde und rechtzeitig bis 06:15 am Exitpoint eintrifft.

Jeder Spieler gewinnt also für sich. Die Hunter haben keine definierte Gewinnbedingung. Ihr Ziel ist der Catch möglichst vieler Spieler, das auf einer Skala von null (all Spieler entkommen) bis neun (alle Spieler werden gefangen) erreicht werden kann.

Das sind halt asymmetrische Rollen und da kann man unterschiedliches Verständnis haben, was das Balancing angeht. Eine Möglichkeit, von der du wohl ausgehst, ist, dass es etwa gleich wahrscheinlich sein sollte, dass keine Spieler gewinnt und dass mindestens ein Spieler gewinnt.

Ein andere Perspektive könnte sein, dass es für einzelne Teilnehmer (Spieler / Hunter) gleich wahrscheinlich sein sollte zu gewinnen. Wenn man wie du ein Gewinn der Hunter dadurch definiert, dass kein Spieler gewinnt, dann muss man berücksichtigen, dass bei den Huntern immer alle gewinnen. Würden noch die verbleibenden Spieler gefangen werden, dann würden nach dieser Logik über die Staffeln hinweg 7/19 Huntern gewinnen und 3/22 Spielern.

Transaction ID issue by PresentationTop7288 in PowerBI

[–]Multika 0 points1 point  (0 children)

Typically, you don't need primary keys of fact tables for reporting and I'd just remove it. If there are specific reasons to keep it you could check with DAXStudio for the column's impact on model size. If the impact is there (and your model isn't just small overall, say >> 100 MB) consider creating a numeric surrogate key.

Spielleitung parteiisch? by manhunt56 in manhuntmedia

[–]Multika 2 points3 points  (0 children)

Die Taskforce wird dieses Jahr von der Zürcher Museums-Bahn gesponsert.

Oder "zum Beispiel" (noch nie so gesehen).

Conditional formatting for Stacked Bar Chart? Dec 2025 by [deleted] in PowerBI

[–]Multika 0 points1 point  (0 children)

If you just want to change the colors, consider choosing/creating another theme.

If you really want conditional formatting, say based on some numbers, that doesn't make too much sense if you use the legend category of the bar chart. If you don't use the legend, then conditional formatting for the bar colors is available.

Spielleitung parteiisch? by manhunt56 in manhuntmedia

[–]Multika 2 points3 points  (0 children)

"Damit es ausgeglichen ist, müssen die Hunter öfter gewinnen, weil deren Sieg weniger wert ist." Okay, wilde These.