Hi guys,
I would love to have this visual like this document attached, with my sales and costs by week, but only with the last 4 or 5 weeks from the chosen date.
Thanks in advance
Pedro
Hi @pedroccamara, we aim to consistently improve the topics being posted on the forum to help you in getting a strong solution faster. While waiting for a response, here are some tips so you can get the most out of the forum and other Enterprise DNA resources.
-
Use the forum search to discover if your query has been asked before by another member.
-
When posting a topic with formula make sure that it is correctly formatted to preformated text </>.
-
Use the proper category that best describes your topic
-
Provide as much context to a question as possible.
-
Include demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.
I also suggest that you check the forum guideline https://forum.enterprisedna.co/t/how-to-use-the-enterprise-dna-support-forum/3951. Not adhering to it may sometimes cause delay in getting an answer.
1 Like
Hi @pedroccamara,
If you can provide us with a PBIX sample that would be great. Otherwise, why donât you use a date filter and then you can choose the period you want to look at. For example in your slicer you can put year & week as in the picture, and then choose how many weeks you want to back at.
steps you can do -
- Set up a Date table. Ensure the date table has a column week Number
- To set up a week number use - WeekNo = WEEKNUM(âDateâ[Date], 2) - â2â indicates your week starts on a Monday
3.Build your measures to calculate Net Revenue, Net Cost & Profits - To set up the week description set up a new column on the date table and define week text description as weekText = COMBINEVALUES("-", FORMAT(âDateâ[Date], âyyyyâ), âDateâ[WeekNo])
- on your report set up a date slicer - change report setting to âBetweenâ
6 Now set up a pivot table. select week text for the Row and the measures in the values - Between the given selected date range all weeks will be displayed as a separate row
let me know if you have any follow up questions
Hello Hassan
I did something between having no answers. I wanted to be automatic and depending on the chosen periode and also vertical, like this pic attached
In the filters section i choose Top N on 1 and by year n week Sort. ButâŚwhat if i would like the week & year on columns and those 5 values on rowsâŚand this what iâm not being able to doâŚ
Otherwise this works. Iâll just have to change my report properly.
Thanks a lot for your help Hassan
Hello and many thanks for your answer,
Yes i did it all but what i wanted is to be automatic and with the measures on rows and year and week on columns. But i did it with a multi-row card. Itâs not perfect the way i would like, but itâs good also.
Thanks anyway
Best regards
Pedro
Sure. Iâm quite new here but i will be more careful next time before posting.
Can you please tell me how can i end a conversation, that is, if itâs needed?
Thanks for the warning
You could use a Matrix Visual and set the measures to show on rows and the rest on columns.
Go to the format section of the Matrix visual and set the property for it like in the picture attached
!
Measures on Rows|145x500
Hey Cristian
I did try it didnât let me. Also, i canât see your pic
And thanks for helping me
Pedro - to get the measures on row - there is an existing option âShow On Rowsâ for matrix table
**
**
then you put weektext 
on column
this is your end result
let me know if that helps
all the best
2 Likes
Hey, thank you so much for that. Didnât knew that one.
But in my case, still donât work. My values are in the values box and in the columns the year&week. It doesnât let me move the values to the rows, even after changing showing on rowsâŚ
Itâs ok, really. I would love to fix this cose i believe it would be better to my report, but i did it with matrix and TOP N filter. It works more or less the same that i want.
Thereâs so many things to learn and so less time for itâŚand i even didnât passed the 5% knowledge⌠
Thank you so much all of you guys
Hello Pedro - you do NOT have to move your Measures that are in the Values section of the matrix table to the Rows.
just go into the Format tab of the matrix and turn on option âSelect on Rowsâ. this will display Measures as rows instead of columnsâŚ
1 Like
Didnât i told you about the 5%âŚ
Thank you so much! Big help!
Hey @C9411010,
Could you, please, teach me how to embed pics in Replys?
Thank you
Absolutely
when you click reply hit on the "upload "icon
select the file from the browse window and voila the picture is added to your reply message <you may see some cryptic text like (upload://ibvHGIY73Kw6OlFrTxjhaYcM46b.png) > but when you hit reply it will post the picture.
let me know if you have question
Hi @pedroccamara, a response on this post has been tagged as âSolutionâ. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Also,weâve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!
1 Like