Štěpán Rešl tirnovar
🏛️
tirnovar
/ gist:cbe33e8026d81a4d78435309b611605b
Created
November 1, 2023 20:33
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| (series as list) => | |
| [ | |
| bfr = List.Buffer(series), | |
| len = List.Count(bfr), | |
| additions = List.Combine( | |
| List.Generate( | |
| () => [ | |
| id = 0, | |
| currVal = bfr{id}, | |
| others = List.Skip(bfr, id + 1) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| svgWaterFall = | |
| /* SETUP */ | |
| // ALL IN SETUP AND STYLES CAN BE UPDATED | |
| // BASE VALUE | |
| VAR _baseValue = 16 // WILL BE USED AS VALUE FOR BASE COLUMN | |
| // INPUT TABLE SETUP | |
| VAR _initTbl = | |
| ADDCOLUMNS ( | |
| SELECTCOLUMNS ( SUMMARIZE ( <TABLE>, <X-AXIS-CATEGORY> ), "@xAxisCategory", <X-AXIS-CATEGORY> ), | |
| "@vl", <MEASURE> |
tirnovar
/ Hills and Falls - DAX SVG Generator.txt
Last active
August 18, 2023 13:38
Hills and Falls - DAX SVG Generator
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* SETUP */ | |
| VAR _initTbl = | |
| ADDCOLUMNS( | |
| SELECTCOLUMNS( | |
| SUMMARIZE( <TABLE>, <X-AXIS-COLUMN> ), | |
| "@yAxisCategory", <X-AXIS-COLUMN> | |
| ), | |
| "@firstLine", <MEASURE-1>, | |
| "@secondLine", <MEASURE-2> | |
| ) |
tirnovar
/ gist:4b97d41c853e80c6bdaafc4e602b221a
Created
July 3, 2023 08:44
Spider chart generated by DAX
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| svgSpiderChart = | |
| /* SETUP */ | |
| VAR _sizeInCard = DIVIDE(600,2.5) // Size of image setted in a the card (+ downscaled to 2.5) | |
| VAR _numberOfCircles = 10 // Number of circles, that will be drawn | |
| VAR _yUpModifier = 15 // Move the chart up, to center it in the card | |
| VAR _rectangleModifier = 1.25 // Modification from a square to rectangle (x axis modification) | |
| VAR _tbl = // ADD YOUR TABLE, CATEGORY COLUMN + MEASURE HERE | |
| ADDCOLUMNS( | |
| SELECTCOLUMNS( | |
| SUMMARIZE( |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| svgBarchart = | |
| VAR _barSpaceSize = 3 | |
| VAR _svgDeclaration = "data:image/svg+xml;utf8," | |
| VAR _svgHeader = "<svg xmlns='http://www.w3.org/2000/svg' x='0px' y='0px' viewBox='0 0 300 300'>" | |
| VAR _svgEnd = "</svg>" | |
| VAR _green = "#95BB4B" | |
| VAR _red = "#A41515" | |
| VAR _grey = "#E6E6E6" | |
| VAR _valuesTbl = | |
| ADDCOLUMNS( |