Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, Please see below. I have 3 columns with name of companies that can repeat row to row. How do I create a table with column 1 and column 2 info that can be filtered by by name of the companies from column 3, 4 and 5? I'd appreciate your help!
Solved! Go to Solution.
Hi @Reh
You may click the project # and project cost columns and then use 'Unpivot other columns' in query editor.Then filter out the blank values.Use the value column as slicer to get the visual.
Regards,
Cherie
Hi @Reh
You may click the project # and project cost columns and then use 'Unpivot other columns' in query editor.Then filter out the blank values.Use the value column as slicer to get the visual.
Regards,
Cherie
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |