How to check for blank column and not to display in bar chart visualization !!!

[Anonymous]

Hello All,

I would like to know if there any possibility to do the following functionality from the single table which contains 5 fields.

Date	Maker	YearMonth	Field 1	Field 2	Field 3	Field 4
1/1/2020	Tesla	202001	99.70%			91.00%
2/1/2020	Tesla	202002	89.00%			92.00%
3/1/2020	Tesla	202003	100.00%			95.00%
4/1/2020	Tesla	202004	99.80%			89.00%
5/1/2020	Tesla	202005	91.00%			99.00%
6/1/2020	Tesla	202006	92.00%			91.00%
7/1/2020	Tesla	202007	95.00%			99.80%
8/1/2020	Tesla	202008	89.00%			97.00%
9/1/2020	Tesla	202009	91.00%			99.80%
10/1/2020	Tesla	202010	99.80%			100.00%
11/1/2020	Tesla	202011	97.00%			89.00%
12/1/2020	Tesla	202012	99.80%			91.00%
1/1/2021	Tesla	202101	100.00%			89.00%
2/1/2021	Tesla	202102	99.00%			91.00%
3/1/2021	Tesla	202103	90.00%			99.80%
4/1/2021	Tesla	202104	93.00%			97.00%
1/1/2020	Ford	202001		91.00%	91.00%
2/1/2020	Ford	202002		99.80%	92.00%
3/1/2020	Ford	202003		97.00%	95.00%
4/1/2020	Ford	202004		99.80%	89.00%
5/1/2020	Ford	202005		100.00%	99.00%

1.  If i select Auto maker and yearmonth as ' Tesla' and ' 202101', I need to validate the fields from Field1, field2, field3 and field4 for blanks. Then i need to display only Field1 and Field 4 which has values and pass it to the chart. Which function to choose when writing in DAX? Do i need to use selected columns?

2. Also I need to display the value for 6 months based on the yearmonth selected. If i know how to validate non blank values and pass multiple columns to the chart, i can handle this scenario using MEASURE by filtering the date for 6 months range.

Kindly assist in this. Appreciate your time. 

[Greg_Deckler · Accepted solution]

@Anonymous Unpivot your Field columns.

[Anonymous]

Thanks for the prompt response. It works

🙂