Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi all.
Well, I have to do 3 Measures.
1 Show values all month
2 Show values selected month
3 Show values partial month
Ex:
link with files https://drive.google.com/open?id=11lCWE0-K-c7J9lAKC9KFnnlq8GAQyhWZ
Solved! Go to Solution.
Hi @Anonymous,
You can refer to below steps to achieve your requirement.
Prerequest:
1. Create two slicer tables based on current table columns.
2. Slicer tables can't contains relationship to original table.
Steps:
1 Write formula to create slicer tables:
Value Slicer = VALUES('Records'[Value]) Month Slicer = VALUES('Records'[Month])
2. Create slicer with above table columns.
3. Write measure based on slicer.
Total Value(All Month) = CALCULATE(SUM('Records'[Value]),ALL('Records'[Month])) Total Value(Selected Month) = SUMX(FILTER(ALL('Records'),[Month] in ALLSELECTED('Month Slicer'[Month])),[Value]) Month Detail = CONCATENATEX(FILTER(ALL('Records'),[Value] in ALLSELECTED('Value Slicer'[Value])),[Month],",")
Result:
Regards,
Xiaoxin Sheng
Hi @Anonymous,
You can refer to below steps to achieve your requirement.
Prerequest:
1. Create two slicer tables based on current table columns.
2. Slicer tables can't contains relationship to original table.
Steps:
1 Write formula to create slicer tables:
Value Slicer = VALUES('Records'[Value]) Month Slicer = VALUES('Records'[Month])
2. Create slicer with above table columns.
3. Write measure based on slicer.
Total Value(All Month) = CALCULATE(SUM('Records'[Value]),ALL('Records'[Month])) Total Value(Selected Month) = SUMX(FILTER(ALL('Records'),[Month] in ALLSELECTED('Month Slicer'[Month])),[Value]) Month Detail = CONCATENATEX(FILTER(ALL('Records'),[Value] in ALLSELECTED('Value Slicer'[Value])),[Month],",")
Result:
Regards,
Xiaoxin Sheng
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.