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.
Hi everyone,
I am new to Power BI coming over from Tableau.
I am trying to reproduce a quite easy functionality from Tableau into Power BI but am failing miserably...
In Tableau, I was using so that the user could select what column to show:
I would like to do this as well in Power BI. Measures are all calculated the same so it is really the data columns that are changing.
I created a separate table 'Fields to Show' with a column called Granularity. The column Granularity contains 2 rows: Location and POS (eg. Shop).
I am now trying to create a calculated column in my main table 'Daily COT' which would either be empty if 'Location' is selected in the table 'Fields to Show' or show the values of the column 'POS' in the Daily COT Table:
Column to Show = IF(SELECTEDVALUE('Fields to Show'[Granularity]) = "POS", 'Daily COT'[POS],BLANK())
However it does not take any of the values, it either takes POS (regardless of the filter) or blank.
Could you please help?
Thanks a lot
Hi @dreyz64
You can not change columns dynamically in power BI. you have do it manually which column needs to be displayed in your visual.
one way to do is
https://powerpivotpro.com/2018/01/dynamic-attributes-power-bi-report/
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.
Thanks Pravin,
Will have a look and come back to you if I have any questions!
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |