Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Transposing data for line chart?

Hi All,   I want to make a line chart from the following data: I want Dates on the X Axis and then number values (for each colour) on the Y Axis.  Then I want the line values to be Ebitda YT...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for this.
Do you know the best way I could work with this data.  Or anywhere I can read more to understand this. I'm finding it difficult to work with data with 3 main parameters 'Metric' 'Date' & 'Color'.  For example I may want to look at some (not all) of the metrics by date and filter by color.  It seems as if I have to sacrifice one and work with 2 of the 3.  

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

Matrix with drilling down/up is good. About filtering, you can filter by the filters or the slicers.

Reference: Drill down and drill up in a visual - Power BI | Microsoft Docs

Add a filter to a report in Power BI - Power BI | Microsoft Docs

Slicers in Power BI - Power BI | Microsoft Docs

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.