Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Is there a way to change the constant line based off the slicer selection? I have a slicer with four different options and each of them have different capacities. Is there a way for a constant horizontal line to change based off the slicer selection wihtout having to manually insert the capacities in the table.
Thanks!
Solved! Go to Solution.
Hi @NoaB ,
You need to add a measure that makes the calculation for each of your option on the slicer, something like this:
Flat Line = SWITCH ( SELECTEDVALUE ( Table2[Capacity] ); "A"; 20; "B"; 25; "C"; 5; "D"; 40; 80 )
This needs to be adjusted to your needs but as you can see below the numbers change accordingly
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @NoaB ,
You need to add a measure that makes the calculation for each of your option on the slicer, something like this:
Flat Line = SWITCH ( SELECTEDVALUE ( Table2[Capacity] ); "A"; 20; "B"; 25; "C"; 5; "D"; 40; 80 )
This needs to be adjusted to your needs but as you can see below the numbers change accordingly
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix ! Thanks for your response!
I tried your approach and I'm still having some issues. Is Table2[Capacity] the table that has a column "Capacity" which results in the options for the slicer?
I attempted thios measure below and was receiving an error "Unexpected expression" for everything starting after the semicolon after "SELECTEDVALUE( HourlyCapacityWithETA[PoolName] );"
Hi @NoaB ,
This as to do with regional settings, on some systems it uses the dot comma on other only comma.
Redo your measure to:
Flat Line = SWITCH( SELECTEDVALUE( HourlyCapacityWithETA[PoolName] ), "Var1", 220, "Var2", 220, "Var3", 70, "Var4", 364 )
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsAmazing! Thank you @MFelix !
Do you know if there is a way to send an alert for static data when the data crossed the capacity line?
Hi @NoaB ,
Can you elaborate on your question please? What do you mean to send out an alert?
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix ,
I've been looking into Power BI's functionality for sending out alerts. However it only works for livestream data for KPIs and gauges visuals. I was wondering if there functionality for a static data set that if the graph reaches a certain threshold a notification can appear.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |