Forum Discussion
Need help with defining the matrix
Hi,
I am looking for a solution on the below item-
I have a matrix visuals which shows monthly data like 2023-Jan, 2023- Feb, 2023-Mar .... 2023-Dec and I have two slicers to select year (slicer 1)and month /quater/half year / full year.(slicer 2)
The requirement is to show two additional columns year-quarter ( like 2023-Q1) and year-halfyear (2023-H1) in the same biew aling with all the months view that was mentioned above.
for example -
If I select 2023 (slicer 1)and Jan (slicer 2) then the matrix will show 2023-Jan and 2023-Q1 and 2013-H1
If I select 2023 and Q1 then the matrix will show 2023- Jan, 2023- Feb, 2023- Mar , 2023-Q1, 2023-H1
If I select 2023 and Q1 then the matrix will show 2023- Jan, 2023- Feb, 2023- Mar , 2023-Q1, 2023-H1
If I select 2023 and H2 then the matrix will show From 2023- Jan, 2023- Feb, 2023- Mar to 2023-Dec and 2023-Q4, 2023-H2
I am fine with the months value but not able to figure out how to populate current quarter and current half year based on the user selection.
Can anyone please provide some insight on how to calculate those two columns and show it in the same matrix
thanks
1 Reply
- lbendlin
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
