Forum Discussion

Belle2015's avatar
Belle2015
Icon for Helper II rankHelper II
1 year ago
Solved

Create a colour measure for a table with multiple columns

Hi,  I have a table thats used each month to show a task is due on a certain day of the month, we input a number 3 if its still to be done 2 if its in progress and 3 when complete, I want to colour ...
Need Help
  • v-achippa's avatar
    v-achippa
    1 year ago

    Hi Belle2015,

     

    The issue here is likely because the Day values in the DayTable not exactly matching the Day values in the unpivoted table.

    • Go to Model view and make sure there is a active relationship between DayTable[Day] to the UnpivotedTable[Day] column. This should be a one-to-many relationship from DayTable to the unpivoted data.
    • Make sure both tables have the exact same values in the Day column. For example if your unpivoted table has ‘10th’ then your DayTable must also contain ‘10th'. Check each day because even small mismatches will prevent the matrix from aligning correctly.
    • Use DayTable[Day] in the Columns field and make sure ‘Show items with no data’ is enabled.

    Once these are done the task statuses should appear correctly under their respective days.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa

Belle2015's avatar
Belle2015
Icon for Helper II rankHelper II
1 year ago

Hi v-achippa , 

 

The sort part of this works perfectly thanks. 

 

The only thing is when I have set up the table and used the Day in the column it is not bringing in the task status under the day, it just has them under a blank column at the begining.

Thanks for your help with this 🙂

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
1 year ago

Hi Belle2015,

 

The issue here is likely because the Day values in the DayTable not exactly matching the Day values in the unpivoted table.

  • Go to Model view and make sure there is a active relationship between DayTable[Day] to the UnpivotedTable[Day] column. This should be a one-to-many relationship from DayTable to the unpivoted data.
  • Make sure both tables have the exact same values in the Day column. For example if your unpivoted table has ‘10th’ then your DayTable must also contain ‘10th'. Check each day because even small mismatches will prevent the matrix from aligning correctly.
  • Use DayTable[Day] in the Columns field and make sure ‘Show items with no data’ is enabled.

Once these are done the task statuses should appear correctly under their respective days.

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

 

Thanks and regards,

Anjan Kumar Chippa