Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@Balaryan58 Unpivot your Field columns.
@Balaryan58 Unpivot your Field columns.
Thanks for the prompt response. It works
🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
51 | |
27 | |
24 | |
14 | |
9 |
User | Count |
---|---|
75 | |
58 | |
47 | |
16 | |
12 |