Forum Discussion

Neymarsh's avatar
Neymarsh
Frequent Visitor
2 years ago

Creating Visual based on running weekly values

Hi all,    My brain is pretty much fried trying to think of the logic behind this so hoping somebody may have done something similar or have a good idea how to create the below chart as a chart wit...
chart
weekly
Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

Neymarsh So, I would recommend potentially using a matrix visual and a disconnected table for your columns. You would then work all of the logic as far as what to display into a measure. Really difficult to be specific here given the information provided. 

 

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.