Forum Discussion
Create Small Multiple Line chart without legends
- 1 year ago
Hi SUMESHKUMAR22
If you want to stay with the new cards you can use a svg sparklines to achieve something similar.
Please refer to the linked video ( from 12 minute ) :
https://www.youtube.com/watch?v=oHAeKf04ne8If you want a small multiple you can instead of using dynamic measure and text boxes like :
To achieve it, you can create a disconnected table like :
Sort the measures by needed order :
Create standard needed measures :
Total Sales = DIVIDE(SUM(Sales[Sales]),1000) Total profits = Divide (sum('Sales'[Profits]),1000) profits% = DIVIDE([Total profits],[Total Sales])*100 Create a dynamic measure :
Dynamic measure = SWITCH(SELECTEDVALUE('Table'[Measure]),"Sales",[Total Sales],"Profits",[Total profits],[profits%])This dynamic measure will be on the Y axis for small multiples :The next step is creating the titles for every section:
Title for Sales =
"Sales K/$ :" & [Total Sales]Title for profits =
"Profits K/$ :" & [Total profits]Title for profits % =
"Profits % :" & FORMAT( [profits%]/100,"0.0%")Now you can take these titles to text boxes and put them on the graphResult (ignore the blue lines they will not be shown after publishing)
You can also group all the elements together:
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- 1 year ago
Hi SUMESHKUMAR22
To mark the last point and that label on a small multiple you can apply these steps:1. Create a Dax measure for the color, which will be with the color you need if we are on the last point, and white transparent if we are not :
last point color = if (SELECTEDVALUE('Calendar'[Month])<>calculate(max('Calendar'[Month]),ALLSELECTED('Calendar'[Month])),"#FFFFFF00","Blue")2. Change the graph type to the clustered / stacked columns :
3. Modify conditional formatting for column color based on the measure that we created:
Now change the graph back to line:
6. Do the same conditional formatting trick with the data labels, based on the same measure :
Result :
The updated pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi SUMESHKUMAR22
If you want to stay with the new cards you can use a svg sparklines to achieve something similar.
Please refer to the linked video ( from 12 minute ) :
https://www.youtube.com/watch?v=oHAeKf04ne8
If you want a small multiple you can instead of using dynamic measure and text boxes like :
To achieve it, you can create a disconnected table like :
Sort the measures by needed order :
Create standard needed measures :
| Total Sales | = | DIVIDE(SUM(Sales[Sales]),1000) |
| Total profits | = | Divide (sum('Sales'[Profits]),1000) |
| profits% | = | DIVIDE([Total profits],[Total Sales])*100 |
Create a dynamic measure :
The next step is creating the titles for every section:
| Title for Sales | = | "Sales K/$ :" & [Total Sales] |
| Title for profits | = | "Profits K/$ :" & [Total profits] |
| Title for profits % | = | "Profits % :" & FORMAT( [profits%]/100,"0.0%") |
Result (ignore the blue lines they will not be shown after publishing)
You can also group all the elements together:
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- Ritaf19831 year agoSuper User
Hi SUMESHKUMAR22
To mark the last point and that label on a small multiple you can apply these steps:1. Create a Dax measure for the color, which will be with the color you need if we are on the last point, and white transparent if we are not :
last point color = if (SELECTEDVALUE('Calendar'[Month])<>calculate(max('Calendar'[Month]),ALLSELECTED('Calendar'[Month])),"#FFFFFF00","Blue")2. Change the graph type to the clustered / stacked columns :
3. Modify conditional formatting for column color based on the measure that we created:
Now change the graph back to line:
6. Do the same conditional formatting trick with the data labels, based on the same measure :
Result :
The updated pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly