Forum Discussion
Creating table rows based on selected value
Hello there, can you advise how I can create rows in Table A based on filtered values from two different tables - they are Numerator and Denominator. I created the below (which doesnt work) that ...
Hi amitchandak , Im looking at your article and it looks like they are combined as separate columns? I want mine to show as separate rows bu the same columns
Anonymous , not very clear .
Union (All(table[column1]),All(table[column2]))
will create two rows for Column 1 and column 2
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi amitchandak
Please see attached workbook. I want to plot whatever is selected in Numerator and Denominator box in one chart
Anonymous , attachment missing
sorry missed that. here it is
https://drive.google.com/file/d/11BXaxM_3h0Y5scTDHtZFAXkPRLrUtTlN/view?usp=sharing