Need help with a DAX measure issue, that doesn't filter correctly.
hi Guys/Girls I've got a measure [FilteredTotal] & [Total], and i'd like to create a measure that returns the value from [Total] when the filter is active on the page, or else if filte is not active return the value for [FilteredTotal]. ConditionalTotal = IF ( ISFILTERED(ChartOfAccounts[Name]), [Total], [FilteredTotal] ) but this doesn't really work, because the value for [Total] still shows when no filter is chosen. what might be the problem? please ask if you need more info to answer/help
Line and stacked column chart does not filter everything that's need to be filtered
So, we have the separate table "At risk parts"(no relationships with any other table) which the visual should be based on this: And a chart that was requested should look like this (3 distinct count of projects on left axis, 3 at risk parts on right axis): "At risk parts" here is a measure based on other table(s). The problem: - Whenever I filter the dashboard the visual should get filtered, too. It gets, but partly. "Line values" part gets filtered fine (whenever I slice, values change as they supposed to), but the "Column Series" and "Column Values" parts of the visual stay the same. How do I get them filtered, too? Is there any DAX measure to help with? I watched a couple of videos on YouTube but didn't get it thank you!
How to remove decimal places from total when value is 100%?
I have table where values are shown with two decimal places, i.e. 6.15%, 3.08% for each row. However when the total equals 100% it is shown as 100.00%? How do I keep the decimal point values for the rows but remove decimal point values for the total when I have 100%? So the total should show 100% instead of 100.00%Metric Switch Formatting Error
I have two metric switch statements. One switch returns the current week data, the other switch is the prior 6 week data. I need to create a Varience between the two, so I need to subtract the two metric switch statements. The issue is that in both metric switch statements, there are 2 measures that need to be formatted as % and I receive an Error: "Cannot convert value '%' of type Text to type numeric/date. I am only formatting the measures to % in the metric switch statements, since metric switchs change data type to default. (Images Below) Note: The formatting of the % works properly in each individual metric switch, just not when I subtract the switches together. I am not sure why I am getting this error when the formatting is the same in the two switch statements. I have been able to subtract metric switch statements in other meausres to get Var, but they didnt have formatting on them. Is there a workaround for this issue or am I just missing something? Thanks in advance!
Conditional formatting issue
Hi all, I have generated the below table with two metrics. The Quality KPI switch = quality KPI switch = SWITCH(TRUE(), [Quality KPI] < -0.1 , "G" , [Quality KPI] <= 0 && [Quality KPI] >= -0.1 , "A" , [Quality KPI] < 1 , "R" ) I would like to apply conditional formatting with three different colors to the quality KPI column using the quality KPI figures I want to apply the following rules to my formatting If Quality KPI is between 0 and - 10% --> "A" and "Color1" If quality KPI is more than - 10% --> "G" and " Color2" If quality KPI is more than 1% or any positiive value --> "R" and "color2". I tried to add the colors into the switch function and also tried the conditional formatting but did not manage to get the expected results Can anyone please help me achieve this or at least guide me on how i can get it done ? Thanks in advanceConditional Formatting font text Amber
Is there a way to change the font colour of a text column [BRAG STATUS] with the values "Green", "Amber" & "Red" I'm able to use conditional formatting to get a value by field for the first values (see pic attached) but it doesn't pick up the amber colour: I've even tried to use a switch function to change the HEX colours but I still cant quite get it Conditional Colour Format = SWITCH(TRUE(),MAX(audit_results[BRAG STATUS])="Green",1,MAX(audit_results[BRAG STATUS])="Amber",2,MAX(audit_results[BRAG STATUS])="Red",3) Any help on this would be great! Thanks,Converting Mailchimp Date to an actual date
Hi. I have original data from Mailchimp for "Send Time" which is not formated as date, and has values like: "2019-05-05T13:24:46+00:00" I can't format this as a date, I get an #Error (it's currently text.) I have a new colum called Date Sent, which works with this formula: Date Sent = left('Campaign Summary'[send_time],10) which at least gets the relevant characters, which still can't be formatted as a date (#Error). I've tried changing the format in the "Modeling" tab. I've also tried doing a third column (I know this is silly) which would do this: format date sent = format('Campaign Summary'[Date Sent],"MM/YY") - which still returns only text. I only want this to customize my table for relative date filtering, which it can't do on text. Another option is to sort it by the text (which at least shows the most recent at the top), but then to limit the table to only the top ten records. Please let me know if there is a solution here. Thank you!
