PBI-DataVizzle
/ 00 M Query Gists
Created
March 7, 2024 12:49
— forked from OscarValerock/00 M Query Gists
M Query Gists
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
| // This gist containt useful pieces of M Query code |
PBI-DataVizzle
/ 00 Web Contents Cheat Sheet
Created
March 7, 2024 12:44
— forked from OscarValerock/00 Web Contents Cheat Sheet
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
| let | |
| P1 = "myParameter1", | |
| P2 = "myParameter2", | |
| #"Header" = Binary.ToText(Text.ToBinary(#"UserName"&":" & #"Password")), | |
| #"BaseURL" = "https://yourwebpage.com/api/3", | |
| #"DaysLogic" = | |
| if | |
| #"JIRA Days" = null | |
| then | |
| "" |
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
| { | |
| "$schema": "https://vega.github.io/schema/vega-lite/v5.json", | |
| "description": "Entry for challenge 03 in the 2024 DVS Du Bois Visualization Contest.", | |
| "usermeta": { | |
| "developedBy": "Madison Giammaria", | |
| "LinkedIn": "https://www.linkedin.com/in/madison-giammaria-58463b33", | |
| "email": "[email protected]" | |
| }, | |
| "padding": 5, | |
| "background": "transparent", |
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
| { | |
| "$schema": "https://vega.github.io/schema/vega-lite/v5.json", | |
| "description": "Entry for challenge 03 in the 2024 DVS Du Bois Visualization Contest.", | |
| "usermeta": { | |
| "developedBy": "Madison Giammaria", | |
| "LinkedIn": "https://www.linkedin.com/in/madison-giammaria-58463b33", | |
| "email": "[email protected]" | |
| }, | |
| "padding": 5, | |
| "background": "transparent", |
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
| { | |
| "$schema": "https://vega.github.io/schema/vega-lite/v5.json", | |
| "description": "Use params to enable light/dark mode", | |
| "usermeta": { | |
| "developedBy": "Madison Giammaria", | |
| "LinkedIn": "https://www.linkedin.com/in/madison-giammaria-58463b33", | |
| "email": "[email protected]" | |
| }, | |
| "view": {"stroke": {"expr": "gridColor"}}, | |
| "background": {"expr": "mode === 'light' ? '#fff' : '#000'"}, |
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
| { | |
| "$schema": "https://vega.github.io/schema/vega/v5.json", | |
| "description": "Entry for challenge 01 in the 2024 DVS Du Bois Visualization Contest.", | |
| "usermeta": { | |
| "developedBy": "Madison Giammaria", | |
| "LinkedIn": "https://www.linkedin.com/in/madison-giammaria-58463b33", | |
| "email": "[email protected]" | |
| }, | |
| "title": { | |
| "text": "NEGRO POPULATION OF GEORGIA BY COUNTIES.", |
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
| { | |
| "data": { | |
| "values": [ | |
| { | |
| "Medium": "Television", | |
| "Advertising Share": 65.8, | |
| "Medium-Type": "Digital" | |
| }, | |
| { | |
| "Medium": "Internet", |
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
| { | |
| "$schema": "https://vega.github.io/schema/vega-lite/v5.2.0.json", | |
| "config": {"view": {"continuousHeight": 300, "continuousWidth": 400}}, | |
| "hconcat": [ | |
| { | |
| "data": { | |
| "name": "Dataset1", | |
| "format": {"type": "json", "property": "data.histogram"}, | |
| "url": "https://gist.githubusercontent.com/hemagso/f7b4381be43b34ece4d8aa78c936c7d5/raw/0bae0177b8a2a5d33e23c0d164d4439d248aa9ff/mock,json" | |
| }, |
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
| { | |
| "$schema": "https://vega.github.io/schema/vega-lite/v5.json", | |
| "data": {"url": "data/cars.json"}, | |
| "params": [ | |
| {"name": "toggleOrigin", "bind": {"input": "checkbox"}}, | |
| {"name": "paintbrush", "select": {"type": "point", "on": "pointerover"}}, | |
| {"name": "brush", "select": "interval"}, | |
| { | |
| "name": "opacityVar", | |
| "value": 50, |
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
| { | |
| "$schema": "https://vega.github.io/schema/vega-lite/v5.json", | |
| "data": { | |
| "values": [ | |
| {"item": "A", "value": 0.85}, | |
| {"item": "AA", "value": 98}, | |
| {"item": "AB", "value": 361}, | |
| {"item": "AC", "value": 1750}, | |
| {"item": "C", "value": 92650}, | |
| {"item": "D", "value": 150000}, |