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 All
currently in Matrix we are using date hierrchy , instead of that we have to select day/week/month based on the selection any of these values used in columns of matrix
I have tried to create a table with values Day , week , Month
tried to create measure like this but columns are not coming only measure are coming
Selected Value =
IF(HASONEVALUE( SelectedValue[column]),
SWITCH(VALUES( SelectedValue[column]),
"Day", Date[Day],
"Week", Date[Week Ending],
"Month", Date[Month] )
), "Please select only one value to display")
Please let me know is there any way to select Date[Day] , Date[Week Ending] ,Date[Month] dynamiclly in matrix
Hi,
I am trying to the same thing but with charts to be able to have, for example, 2016 selected, then able to switch between "Monthly", "Weekly" and "Daily" so that the axis scales based on the selection.
No luck as yet but I hope someone else can assist or MS updates PBI so that it can.
Darshik
I am not very clear about your requirement, please help to share sample data of your table and post expected result with screenshot.
If you want to dynamically hide column in Matrix based on selection, it is not possible. One option is to hide or show the values in the column by creating measures, but column headers are still appeared even there is no data.
Regards,
Lydia
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |