Forum Discussion
Matrix with Weekly Data Columns and String Values
I'm new to PowerBI and I'm trying to create the visualization below and am having trouble because of a few areas: 1. I am getting an error with dates because there are gaps in the dates ...
Hi Anonymous,
I'm assuming that you want to return Yes when measure is greater than target.
Use the following measure to add to your matrix:
YES / NO = IF ( HASONEFILTER ( Data[Week Starting] ); IF ( SUM ( Data[Measure] ) < SUM ( Data[Target] ); "No"; "Yes" ); COUNTROWS ( FILTER ( SUMMARIZE ( Data; Data[Week Starting]; "YES/NO"; SUM ( Data[Measure] ) - SUM ( Data[Target] ) ); [YES/NO] > 0 ) ) )Regards,
MFelix
Hi Anonymous,
Select the date column then select the modeling on the bar and format the date as you need.
Regards,
MFelix
MFelix
Super User
Super UserHi Anonymous,
I'm assuming that you want to return Yes when measure is greater than target.
Use the following measure to add to your matrix:
YES / NO =
IF (
HASONEFILTER ( Data[Week Starting] );
IF ( SUM ( Data[Measure] ) < SUM ( Data[Target] ); "No"; "Yes" );
COUNTROWS (
FILTER (
SUMMARIZE (
Data;
Data[Week Starting];
"YES/NO"; SUM ( Data[Measure] ) - SUM ( Data[Target] )
);
[YES/NO] > 0
)
)
)
Regards,
MFelix
Thanks Felix!! This is great! Any advice on how to adjust the format of the dates as columns?
Cheers,
Julian
- MFelix
Hi Anonymous,
Select the date column then select the modeling on the bar and format the date as you need.
Regards,
MFelix