cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AClerk Member
Member

Formatting non existing values

Hey,

Lets say I have a column chart. I derive the data from a table and I want to show the number of records by status.

Potentialy, I have 5 different statuses in the table. But currently there are only 4 existing values.

I want to format the colors of the bars.

How can I format the 5th value? It is not in the table, but it will be there in the future.

Thanks

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Formatting non existing values

I'd suggest creating a brand new table using "Enter Data" with 1 row for each of your known values.  Link this table (1 to many) to your data table.

 

Now in your visual, put in the column from your Enter data table and format as you expected.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


Super User
Super User

Re: Formatting non existing values

Based on the description of your problem, you want to pre-configure the colours of your values. How else would you set up a configuration of those colours without something that requires maintenance?  The use of "Enter Data" of a linked table is about as tiny as the mainentance could be.

 

The only "half way between" I can think of would be for you to create a Theme file, and make sure you have the correct colouring in the order you want.  This will still be a dynamic solution, but you would have some amount of control on what colours should turn up.  This won't ever be perfect, as sometimes your colouring might get out of order if there are uncontrollable circumstances (such as a missing data value changing the ordering).


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


4 REPLIES 4
Super User
Super User

Re: Formatting non existing values

I'd suggest creating a brand new table using "Enter Data" with 1 row for each of your known values.  Link this table (1 to many) to your data table.

 

Now in your visual, put in the column from your Enter data table and format as you expected.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


AClerk Member
Member

Re: Formatting non existing values

Hi @Ross73312

Thanks for the answer.

While it is valid technically, th sollution is hard to maintain.

I might have a few cases like this and the solution will be hard to maintain.

For example, the values might change with time in a few places in my report(s).

 

Cheers mate!

Super User
Super User

Re: Formatting non existing values

Based on the description of your problem, you want to pre-configure the colours of your values. How else would you set up a configuration of those colours without something that requires maintenance?  The use of "Enter Data" of a linked table is about as tiny as the mainentance could be.

 

The only "half way between" I can think of would be for you to create a Theme file, and make sure you have the correct colouring in the order you want.  This will still be a dynamic solution, but you would have some amount of control on what colours should turn up.  This won't ever be perfect, as sometimes your colouring might get out of order if there are uncontrollable circumstances (such as a missing data value changing the ordering).


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


Highlighted
AClerk Member
Member

Re: Formatting non existing values

Hi,

Guess there is no better options.

Thank you for the answers.

A