Forum Discussion
Solved
Add column value if it doesn't exist
Hi, I am looking for help please. Not sure if this belongs here or in the power query section. Any help or guidance much appreciated. I have a table with data similar to the below sample. There is ...
Hi TAD80
- Create a Dimension Table for the Ratings. Add all possible ratings in here, including Critical Risk.
- Make sure that they are spelt the same as what is in your table
- Create a one to many relationship from your new table's column to the Ratings column and make sure that it is active
- In you bar chart add the new column from the new table in the x axis.
- Then add the measure Count of Risk. It won't show Critical Risk at this stage
- On the right side where you added the new column name, right click and choose "Show items with no data"
- You will then see in the x axis, the Critical Risk column. It will be empty, but you see in the axis that there are none.
Hope this helps
Joe
Hi TAD80
- Create a Dimension Table for the Ratings. Add all possible ratings in here, including Critical Risk.
- Make sure that they are spelt the same as what is in your table
- Create a one to many relationship from your new table's column to the Ratings column and make sure that it is active
- In you bar chart add the new column from the new table in the x axis.
- Then add the measure Count of Risk. It won't show Critical Risk at this stage
- On the right side where you added the new column name, right click and choose "Show items with no data"
- You will then see in the x axis, the Critical Risk column. It will be empty, but you see in the axis that there are none.
Hope this helps
Joe
Thank very much Joe This worked for me!