Forum Discussion
Dinamic columns?
And you'll have your dynamic columns. If some value changes, the table will adjust the view.
Let me know if it works.
#I'M Not An Expert#
its quite hard to explain, and probably i want to use powerbi for something it wasnt created for :D
the functions i ve created, report "1 or 0", are actually "reading" the data from the table, and report yes or no, if they find the data they are related to.
Example. Function 1. reads the table protocol (ej protocolA = row1), looking if he finds the word, -car- other function reads for the word -house-, and so on for over 100 functions,, (each row/protocol is a largeeee data set of information, wich explains why im doing this, since i want to be able to agregate the data in the future)
Now imagine, if i want to check out protocol A, the table would be too large to visualize properly (1 row and >100 columns),
if i do the visual filter, i would be forcing power bi to show me , the functions that I want to be 1. (if i choose 35 functions to be 1, it will show me only the row that is 1 in the all 35 functions, and thats not what im looking for), if i choose any other filter option it will show me all the functions, since the results are only 1 or 0.
Instead, i want to be able to tell power bi, ok. i have protocol A, show me all the functions its 1 for, avoiding 0 (here is where columns would be dinamic, since the result would be azarous,.
Protocol A, would have only 5 functions that are positive = 5 columns.
Protocol B, would have 15 functions positive = 15 columns.
ect,
Sorry if im not clear enough,, my english and the complexity of the idea are a bad combination.,,,
- Not really. Im sorry.
Guess nobody thought it was usefull. Yet i still belive this would be great for datasets with large amount of conditional columns.
If people here support the idea, may be powerbi staff will think about adding it to future updates.
