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 Experts,
I have the table as below :
I have the two slicers:
1. Country
2. Month
what I need is, If I select the country and Month then the measure should calculate the "Jan" column and filter the country column and Code column then values should appear for 6025 against the Item code.
please help me to acheive this.
Regards
Swamy
Solved! Go to Solution.
thanks for the reply, but already i have found the solution.
My measure as below:
Hi @Swamy3105 ,
You may combine all month columns into one month column, enter into Query Editor, click on all the month columns at the same time, go to transfer->Unpivot Columns to get picture 2, you can rename the column Attribute to Month, click "Close & Apply" button.
Then you can put the month into Slicer visual, create measure to get sum total like DAX below.
6025= CALCULATE(SUM(OPEX[Value]),FILTER(ALLSELECTED(OPEX), OPEX[Month] =MAX(OPEX[Month])&&OPEX[Code] = "6025"))
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thanks for the reply, but already i have found the solution.
My measure as below:
Hi @Swamy3105
You can Unpivot your data in Query Editor.
Go to > Edit Queries > Select Your Table > Select All the Month Columns > Click Unpivot Columns as below
This will create two columns Attribute for Months and Value for your Values
Now you can rename Attribute column to Month and use it in a slicer
the Month column is a calculated column.
whenever I select month from slicer then the value should filtered and change based on the slection .
I was referring to Month Columns ( Jan, Feb ....)
Hope this helps.
it's not working.
I have a measure as below:
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 |